DBA Data[Home] [Help]

APPS.BEN_DETERMINE_ACTUAL_PREMIUM dependencies on BEN_ENRT_PREM

Line 85: - Bulk inserted ben_enrt_prem.

81: is not applied. So nvl applied
82: around l_vr_trtmt_cd.
83: 07-Nov-00 mhoyes 115.31 - Added electable choice context
84: global.
85: - Bulk inserted ben_enrt_prem.
86: 22-Nov-00 mhoyes 115.32 - Changed bulk bind composite data
87: structure to a varray. This avoids
88: random composite error on 8.1.6.2.
89: 05-Jan-01 kmahendr 115.33 - Added per_in_ler_id parameter to perpil_cache

Line 1205: INSERT INTO ben_enrt_prem

1201: ,p_program_update_date => l_program_update_date_va(i)
1202: );
1203: else
1204: --
1205: INSERT INTO ben_enrt_prem
1206: (enrt_prem_id,
1207: val,
1208: uom,
1209: elig_per_elctbl_chc_id,

Line 1251: (ben_enrt_prem_s.nextval,

1247: program_id,
1248: program_update_date
1249: )
1250: VALUES
1251: (ben_enrt_prem_s.nextval,
1252: l_val_va(i),
1253: l_uom_va(i),
1254: l_elig_per_elctbl_chc_id_va(i),
1255: l_enrt_bnft_id_va(i),

Line 1301: INSERT INTO ben_enrt_prem

1297: --
1298: else
1299: --
1300: FORALL i IN l_elig_per_elctbl_chc_id_va.FIRST .. l_elig_per_elctbl_chc_id_va.LAST
1301: INSERT INTO ben_enrt_prem
1302: (enrt_prem_id,
1303: val,
1304: uom,
1305: elig_per_elctbl_chc_id,

Line 1347: (ben_enrt_prem_s.nextval,

1343: program_id,
1344: program_update_date
1345: )
1346: VALUES
1347: (ben_enrt_prem_s.nextval,
1348: l_val_va(i),
1349: l_uom_va(i),
1350: l_elig_per_elctbl_chc_id_va(i),
1351: l_enrt_bnft_id_va(i),