DBA Data[Home] [Help]

APPS.HR_CHANGE_START_DATE_API dependencies on BEN_PTNL_LER_FOR_PER

Line 910: FROM ben_ptnl_ler_for_per

906: procedure check_ben_enteries(p_person_id number, p_old_start_date date) is
907:
908: cursor c_ben is
909: SELECT 1
910: FROM ben_ptnl_ler_for_per
911: WHERE person_id = p_person_id
912: and LF_EVT_OCRD_DT >= p_old_start_date
913: and ptnl_ler_for_per_stat_cd not in ('VOIDD','BCKDT');
914: