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 1141: INSERT INTO ben_enrt_prem

1137: ,p_program_update_date => l_program_update_date_va(i)
1138: );
1139: else
1140: --
1141: INSERT INTO ben_enrt_prem
1142: (enrt_prem_id,
1143: val,
1144: uom,
1145: elig_per_elctbl_chc_id,

Line 1187: (ben_enrt_prem_s.nextval,

1183: program_id,
1184: program_update_date
1185: )
1186: VALUES
1187: (ben_enrt_prem_s.nextval,
1188: l_val_va(i),
1189: l_uom_va(i),
1190: l_elig_per_elctbl_chc_id_va(i),
1191: l_enrt_bnft_id_va(i),

Line 1237: INSERT INTO ben_enrt_prem

1233: --
1234: else
1235: --
1236: FORALL i IN l_elig_per_elctbl_chc_id_va.FIRST .. l_elig_per_elctbl_chc_id_va.LAST
1237: INSERT INTO ben_enrt_prem
1238: (enrt_prem_id,
1239: val,
1240: uom,
1241: elig_per_elctbl_chc_id,

Line 1283: (ben_enrt_prem_s.nextval,

1279: program_id,
1280: program_update_date
1281: )
1282: VALUES
1283: (ben_enrt_prem_s.nextval,
1284: l_val_va(i),
1285: l_uom_va(i),
1286: l_elig_per_elctbl_chc_id_va(i),
1287: l_enrt_bnft_id_va(i),