DBA Data[Home] [Help]

APPS.BEN_APR_BUS dependencies on HR_LOOKUPS

Line 558: if hr_api.not_exists_in_hr_lookups

554: and p_rndg_cd is not null then
555: --
556: -- check if value of lookup falls within lookup type.
557: --
558: if hr_api.not_exists_in_hr_lookups
559: (p_lookup_type => 'BEN_RNDG',
560: p_lookup_code => p_rndg_cd,
561: p_effective_date => p_effective_date) then
562: --

Line 627: if hr_api.not_exists_in_hr_lookups

623: and p_prdct_cd is not null then
624: --
625: -- check if value of lookup falls within lookup type.
626: --
627: if hr_api.not_exists_in_hr_lookups
628: (p_lookup_type => 'BEN_PRDCT',
629: p_lookup_code => p_prdct_cd,
630: p_effective_date => p_effective_date) then
631: --

Line 696: if hr_api.not_exists_in_hr_lookups

692: and p_mlt_cd is not null then
693: --
694: -- check if value of lookup falls within lookup type.
695: --
696: if hr_api.not_exists_in_hr_lookups
697: (p_lookup_type => 'BEN_ACTL_PREM_MLT',
698: p_lookup_code => p_mlt_cd,
699: p_effective_date => p_effective_date) then
700: --

Line 771: if hr_api.not_exists_in_hr_lookups

767: and p_prtl_mo_det_mthd_cd is not null then
768: --
769: -- check if value of lookup falls within lookup type.
770: --
771: if hr_api.not_exists_in_hr_lookups
772: (p_lookup_type => 'BEN_PRTL_MO_DET_MTHD',
773: p_lookup_code => p_prtl_mo_det_mthd_cd,
774: p_effective_date => p_effective_date) then
775: --

Line 841: if hr_api.not_exists_in_hr_lookups

837: --
838: -- check if value of lookup falls within lookup type.
839: --
840: --
841: if hr_api.not_exists_in_hr_lookups
842: (p_lookup_type => 'BEN_RT_TYP',
843: p_lookup_code => p_rt_typ_cd,
844: p_effective_date => p_effective_date) then
845: --

Line 911: if hr_api.not_exists_in_hr_lookups

907: --
908: -- check if value of lookup falls within lookup type.
909: --
910: --
911: if hr_api.not_exists_in_hr_lookups
912: (p_lookup_type => 'BEN_BNFT_RT_TYP',
913: p_lookup_code => p_bnft_rt_typ_cd,
914: p_effective_date => p_effective_date) then
915: --

Line 981: if hr_api.not_exists_in_hr_lookups

977: --
978: -- check if value of lookup falls within lookup type.
979: --
980: --
981: if hr_api.not_exists_in_hr_lookups
982: (p_lookup_type => 'BEN_ACTY_REF_PERD',
983: p_lookup_code => p_acty_ref_perd_cd,
984: p_effective_date => p_effective_date) then
985: --

Line 1444: l_mlt_cd hr_lookups.lookup_code%TYPE; -- UTF varchar2(30);

1440: p_business_group_id in number) is
1441: --
1442: l_proc varchar2(72) := g_package||'chk_asg_vrbl_prfl_mlt_tmt';
1443: l_api_updating boolean;
1444: l_mlt_cd hr_lookups.lookup_code%TYPE; -- UTF varchar2(30);
1445: l_vrbl_rt_trtmt_cd hr_lookups.lookup_code%TYPE; -- UTF varchar2(30);
1446: --
1447: cursor c1 is
1448: select vpf.mlt_cd, vpf.vrbl_rt_trtmt_cd

Line 1445: l_vrbl_rt_trtmt_cd hr_lookups.lookup_code%TYPE; -- UTF varchar2(30);

1441: --
1442: l_proc varchar2(72) := g_package||'chk_asg_vrbl_prfl_mlt_tmt';
1443: l_api_updating boolean;
1444: l_mlt_cd hr_lookups.lookup_code%TYPE; -- UTF varchar2(30);
1445: l_vrbl_rt_trtmt_cd hr_lookups.lookup_code%TYPE; -- UTF varchar2(30);
1446: --
1447: cursor c1 is
1448: select vpf.mlt_cd, vpf.vrbl_rt_trtmt_cd
1449: from ben_vrbl_rt_prfl_f vpf,

Line 1571: if hr_api.not_exists_in_hr_lookups

1567: and p_prem_asnmt_cd is not null then
1568: --
1569: -- check if value of lookup falls within lookup type.
1570: --
1571: if hr_api.not_exists_in_hr_lookups
1572: (p_lookup_type => 'BEN_PREM_ASNMT',
1573: p_lookup_code => p_prem_asnmt_cd,
1574: p_effective_date => p_effective_date) then
1575: --

Line 1596: if hr_api.not_exists_in_hr_lookups

1592: and p_prem_asnmt_lvl_cd is not null then
1593: --
1594: -- check if value of lookup falls within lookup type.
1595: --
1596: if hr_api.not_exists_in_hr_lookups
1597: (p_lookup_type => 'BEN_PREM_ASNMT_LVL',
1598: p_lookup_code => p_prem_asnmt_lvl_cd,
1599: p_effective_date => p_effective_date) then
1600: --

Line 1621: if hr_api.not_exists_in_hr_lookups

1617: and p_actl_prem_typ_cd is not null then
1618: --
1619: -- check if value of lookup falls within lookup type.
1620: --
1621: if hr_api.not_exists_in_hr_lookups
1622: (p_lookup_type => 'BEN_PREM_TYP',
1623: p_lookup_code => p_actl_prem_typ_cd,
1624: p_effective_date => p_effective_date) then
1625: --

Line 1646: if hr_api.not_exists_in_hr_lookups

1642: and p_prem_pyr_cd is not null then
1643: --
1644: -- check if value of lookup falls within lookup type.
1645: --
1646: if hr_api.not_exists_in_hr_lookups
1647: (p_lookup_type => 'BEN_PREM_PYR',
1648: p_lookup_code => p_prem_pyr_cd,
1649: p_effective_date => p_effective_date) then
1650: --

Line 1671: if hr_api.not_exists_in_hr_lookups

1667: and p_prsptv_r_rtsptv_cd is not null then
1668: --
1669: -- check if value of lookup falls within lookup type.
1670: --
1671: if hr_api.not_exists_in_hr_lookups
1672: (p_lookup_type => 'BEN_PRSPCTV_R_RTSPCTV',
1673: p_lookup_code => p_prsptv_r_rtsptv_cd,
1674: p_effective_date => p_effective_date) then
1675: --