- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
SELECT POL_PREMIUM
INTO i_csp
FROM policy
WHERE
policy_key = i_polkey AND
pol_status_cde = 1;
SELECT POL_CLIENT_CDE
INTO i_clientno
FROM policy
WHERE policy_key = i_polkey
AND pol_status_cde = 1;
SELECT POL_PLAN_CDE
INTO i_plan
FROM policy
WHERE policy_key = i_polkey
AND pol_status_cde = 1;
SELECT 110
INTO i_SecAllrks
FROM DUAL;