DBA Data[Home] [Help]

APPS.BEN_EFC_ADJUSTMENTS dependencies on BEN_PL_F

Line 102: from ben_pl_f pln

98: ,c_eff_date date
99: )
100: is
101: select pln.pl_id
102: from ben_pl_f pln
103: where pln.pl_id = c_pln_id
104: and c_eff_date
105: between pln.effective_start_date
106: and pln.effective_end_date;

Line 2934: from ben_pl_f pln

2930: is
2931: select pln.creation_date,
2932: pln.last_update_date,
2933: pln.object_version_number
2934: from ben_pl_f pln
2935: where pln.pl_id = c_pln_id
2936: and c_eff_date
2937: between pln.effective_start_date and pln.effective_end_date;
2938: --