APPS.BEN_FORFEITURE_CONCURRENT dependencies on BEN_PL_F

Line 21: * to ben_pl_frfs_val_f table.

17: * program.
18: * 29-Sep-01 pbodla 115.2 Modified cursors to filter based on
19: * provided comp object parameters.
20: * 02-oct-01 pbodla 115.3 Added logic to write forfeiture data
21: * to ben_pl_frfs_val_f table.
22: * In Phase 2 use the actual api's.
23: * 03-Oct-01 pbodla 115.4 Added cursor c_abr_temp to get
24: * clf row for contribution abr.
25: * This is a temporary fix needs to be

Line 84: from ben_pl_f pln

80: cursor c_pln
81: is
82: select pln.nip_acty_ref_perd_cd
83: ,pln.pl_id
84: from ben_pl_f pln
85: where pln.pl_id = p_pl_id
86: and p_effective_date
87: between pln.effective_start_date
88: and pln.effective_end_date;

Line 365: from ben_pl_f pln,

361: pln.BNDRY_PERD_CD,
362: pyp.Acpt_clm_rqsts_thru_dt,
363: yp.start_date,
364: yp.end_date
365: from ben_pl_f pln,
366: ben_popl_yr_perd pyp,
367: ben_yr_perd yp
368: where pln.pl_id = p_pl_id
369: and pln.pl_id = pyp.pl_id

Line 835: -- Write to table ben_pl_frfs_val_f

831: benutils.write(p_rec => g_rec);
832: --
833: if l_pl_subj_frfs.frfs_distr_mthd_cd = 'PRVDR' then
834: --
835: -- Write to table ben_pl_frfs_val_f
836: -- Check whether there exists any row already for
837: -- l_start_date, l_end_date and with final_clms_thru_dt.
838: -- If exists update it else create one.
839: -- Use the actual api's once the api's are generated.

Line 841: delete from ben_pl_frfs_val_f

837: -- l_start_date, l_end_date and with final_clms_thru_dt.
838: -- If exists update it else create one.
839: -- Use the actual api's once the api's are generated.
840: --
841: delete from ben_pl_frfs_val_f
842: where pl_id = p_pl_id
843: and business_group_id = p_business_group_id
844: and start_date = l_start_date
845: and end_date = l_end_date

Line 848: insert into BEN_PL_FRFS_VAL_F

844: and start_date = l_start_date
845: and end_date = l_end_date
846: ;
847: --
848: insert into BEN_PL_FRFS_VAL_F
849: (PL_FRFS_VAL_ID
850: ,EFFECTIVE_START_DATE
851: ,EFFECTIVE_END_DATE
852: ,BUSINESS_GROUP_ID

Line 864: ben_pl_frfs_val_f_s.nextval,

860: ,COST_ALLOC_KEYFLEX_2_ID
861: ,OBJECT_VERSION_NUMBER
862: ) values
863: (
864: ben_pl_frfs_val_f_s.nextval,
865: p_effective_date,
866: hr_api.g_eot,
867: p_business_group_id,
868: p_pl_id,

Line 1238: from ben_pl_f pln

1234:
1235: -- Plans subjected to forfeiture to be processed:
1236: cursor c_pl_subj_frfs (p_effective_date date) is
1237: select pln.*
1238: from ben_pl_f pln
1239: where pln.business_group_id = p_business_group_id
1240: and pln.frfs_aply_flag = 'Y'
1241: and pln.pl_stat_cd = 'A'
1242: and pln.pl_id = NVL(p_pl_id, pln.pl_id)