DBA Data[Home] [Help]

APPS.HR_CAGR_ENT_LINES_API dependencies on BEN_PRTN_ELIG_F

Line 459: ben_prtn_elig_f b1

455: CURSOR get_prtn_elig_prfl_id IS
456: SELECT b2.prtn_elig_prfl_id,
457: b2.object_version_number
458: FROM ben_prtn_elig_prfl_f b2,
459: ben_prtn_elig_f b1
460: WHERE p_effective_date BETWEEN b2.effective_start_Date
461: AND b2.effective_end_date
462: AND b2.prtn_elig_id = b1.prtn_elig_id
463: AND b1.oipl_id = p_oipl_id

Line 704: ben_prtn_elig_f bpe,

700: bpe.object_version_number,
701: bep.prtn_elig_prfl_id,
702: bep.object_version_number
703: FROM ben_prtn_elig_prfl_f bep,
704: ben_prtn_elig_f bpe,
705: ben_oipl_f bof,
706: per_cagr_entitlement_lines_f pcl
707: WHERE bep.prtn_elig_id = bpe.prtn_elig_id
708: AND bpe.oipl_id = bof.oipl_id