APPS.BEN_PDP_BUS dependencies on HR_LOOKUPS

Line 124: if hr_api.not_exists_in_hr_lookups

120: --
121: -- check if value of lookup falls within lookup type.
122: --
123: --
124: if hr_api.not_exists_in_hr_lookups
125: (p_lookup_type => 'YES_NO',
126: p_lookup_code => p_ovrdn_flag,
127: p_effective_date => p_effective_date) then
128: --

Line 188: if hr_api.not_exists_in_hr_lookups

184: --
185: -- check if value of lookup falls within lookup type.
186: --
187: --
188: if hr_api.not_exists_in_hr_lookups
189: (p_lookup_type => 'YES_NO',
190: p_lookup_code => p_cvg_pndg_flag,
191: p_effective_date => p_effective_date) then
192: --

Line 922: hr_lookups lkp,

918: FROM ben_crt_ordr crt,
919: ben_crt_ordr_cvrd_per cvr,
920: per_all_people_f per,
921: per_contact_relationships con,
922: hr_lookups lkp,
923: ben_pl_f bpl
924: WHERE crt.crt_ordr_typ_cd IN ('QMCSO','QDRO')
925: AND crt.person_id = rslt_person_id
926: AND crt.pl_id = rslt_pl_id

Line 969: hr_lookups lkp,

965: FROM ben_crt_ordr crt,
966: ben_crt_ordr_cvrd_per cvr,
967: per_all_people_f per,
968: per_contact_relationships con,
969: hr_lookups lkp,
970: ben_pl_typ_f bpt
971: WHERE crt.crt_ordr_typ_cd IN ('QMCSO','QDRO')
972: AND crt.person_id = rslt_person_id
973: AND crt.pl_typ_id = l_pl_typ_id_pl