APPS.BEN_PEN_BUS dependencies on HR_LOOKUPS

Line 121: if hr_api.not_exists_in_hr_lookups

117: --
118: -- check if value of lookup falls within lookup type.
119: --
120: --
121: if hr_api.not_exists_in_hr_lookups
122: (p_lookup_type => 'YES_NO',
123: p_lookup_code => p_enrt_ovridn_flag,
124: p_effective_date => p_effective_date) then
125: --

Line 191: if hr_api.not_exists_in_hr_lookups

187: --
188: -- check if value of lookup falls within lookup type.
189: --
190: --
191: if hr_api.not_exists_in_hr_lookups
192: (p_lookup_type => 'YES_NO',
193: p_lookup_code => p_no_lngr_elig_flag,
194: p_effective_date => p_effective_date) then
195: --

Line 263: if hr_api.not_exists_in_hr_lookups

259: --
260: -- check if value of lookup falls within lookup type.
261: --
262: --
263: if hr_api.not_exists_in_hr_lookups
264: (p_lookup_type => 'BEN_ENRT_RSLT_MTHD',
265: p_lookup_code => p_enrt_mthd_cd,
266: p_effective_date => p_effective_date) then
267: --

Line 406: if hr_api.not_exists_in_hr_lookups

402: --
403: -- check if value of lookup falls within lookup type.
404: --
405: --
406: if hr_api.not_exists_in_hr_lookups
407: (p_lookup_type => 'YES_NO',
408: p_lookup_code => p_prtt_is_cvrd_flag,
409: p_effective_date => p_effective_date) then
410: --

Line 476: if hr_api.not_exists_in_hr_lookups

472: --
473: -- check if value of lookup falls within lookup type.
474: --
475: --
476: if hr_api.not_exists_in_hr_lookups
477: (p_lookup_type => 'YES_NO',
478: p_lookup_code => p_sspndd_flag,
479: p_effective_date => p_effective_date) then
480: --

Line 546: if hr_api.not_exists_in_hr_lookups

542: --
543: -- check if value of lookup falls within lookup type.
544: --
545: --
546: if hr_api.not_exists_in_hr_lookups
547: (p_lookup_type => 'BEN_COMP_LVL',
548: p_lookup_code => p_comp_lvl_cd,
549: p_effective_date => p_effective_date) then
550: --

Line 616: if hr_api.not_exists_in_hr_lookups

612: and p_bnft_nnmntry_uom is not null then
613: --
614: -- check if value of lookup falls within lookup type.
615: --
616: if hr_api.not_exists_in_hr_lookups
617: (p_lookup_type => 'BEN_NNMNTRY_UOM',
618: p_lookup_code => p_bnft_nnmntry_uom,
619: p_effective_date => p_effective_date) then
620: --

Line 684: if hr_api.not_exists_in_hr_lookups

680: and p_bnft_typ_cd is not null then
681: --
682: -- check if value of lookup falls within lookup type.
683: --
684: if hr_api.not_exists_in_hr_lookups
685: (p_lookup_type => 'BEN_BNFT_TYP',
686: p_lookup_code => p_bnft_typ_cd,
687: p_effective_date => p_effective_date) then
688: --

Line 753: if hr_api.not_exists_in_hr_lookups

749: and p_prtt_enrt_rslt_stat_cd is not null then
750: --
751: -- check if value of lookup falls within lookup type.
752: --
753: if hr_api.not_exists_in_hr_lookups
754: (p_lookup_type => 'BEN_PRTT_ENRT_RSLT_STAT',
755: p_lookup_code => p_prtt_enrt_rslt_stat_cd,
756: p_effective_date => p_effective_date) then
757: --

Line 823: if hr_api.not_exists_in_hr_lookups

819: and p_enrt_ovrid_rsn_cd is not null then
820: --
821: -- check if value of lookup falls within lookup type.
822: --
823: if hr_api.not_exists_in_hr_lookups
824: (p_lookup_type => 'BEN_OVRID_RSN',
825: p_lookup_code => p_enrt_ovrid_rsn_cd,
826: p_effective_date => p_effective_date) then
827: --

Line 906: hr_lookups lkp,

902: FROM ben_crt_ordr crt,
903: ben_crt_ordr_cvrd_per cvr,
904: per_all_people_f per,
905: per_contact_relationships con,
906: hr_lookups lkp,
907: ben_pl_f bpl
908: WHERE crt.crt_ordr_typ_cd IN ('QMCSO','QDRO')
909: AND crt.person_id = p_person_id
910: AND crt.pl_id = p_pl_id

Line 952: hr_lookups lkp,

948: FROM ben_crt_ordr crt,
949: ben_crt_ordr_cvrd_per cvr,
950: per_all_people_f per,
951: per_contact_relationships con,
952: hr_lookups lkp,
953: ben_pl_typ_f bpt
954: WHERE crt.crt_ordr_typ_cd IN ('QMCSO','QDRO')
955: AND crt.person_id = p_person_id
956: AND crt.pl_typ_id = l_pl_rec.pl_typ_id