eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ABR_BUS dependencies on HR_LOOKUPS

Line 419: if hr_api.not_exists_in_hr_lookups

415: and p_ordr_num is not null then
416: --
417: -- check if value of lookup falls within lookup type.
418: --
419: if hr_api.not_exists_in_hr_lookups
420: (p_lookup_type => 'BEN_RT_ORDR_NUM',
421: p_lookup_code => to_char(p_ordr_num),
422: p_effective_date => p_effective_date) then
423: --

Line 1567: if hr_api.not_exists_in_hr_lookups

1563: and p_use_to_calc_net_flx_cr_flag is not null then
1564: --
1565: -- check if value of lookup falls within lookup type.
1566: --
1567: if hr_api.not_exists_in_hr_lookups
1568: (p_lookup_type => 'YES_NO',
1569: p_lookup_code => p_use_to_calc_net_flx_cr_flag,
1570: p_effective_date => p_effective_date) then
1571: --

Line 1589: if hr_api.not_exists_in_hr_lookups

1585: and p_asn_on_enrt_flag is not null then
1586: --
1587: -- check if value of lookup falls within lookup type.
1588: --
1589: if hr_api.not_exists_in_hr_lookups
1590: (p_lookup_type => 'YES_NO',
1591: p_lookup_code => p_asn_on_enrt_flag,
1592: p_effective_date => p_effective_date) then
1593: --

Line 1612: if hr_api.not_exists_in_hr_lookups

1608: and p_abv_mx_elcn_val_alwd_flag is not null then
1609: --
1610: -- check if value of lookup falls within lookup type.
1611: --
1612: if hr_api.not_exists_in_hr_lookups
1613: (p_lookup_type => 'YES_NO',
1614: p_lookup_code => p_abv_mx_elcn_val_alwd_flag,
1615: p_effective_date => p_effective_date) then
1616: --

Line 1635: if hr_api.not_exists_in_hr_lookups

1631: and p_blw_mn_elcn_alwd_flag is not null then
1632: --
1633: -- check if value of lookup falls within lookup type.
1634: --
1635: if hr_api.not_exists_in_hr_lookups
1636: (p_lookup_type => 'YES_NO',
1637: p_lookup_code => p_blw_mn_elcn_alwd_flag,
1638: p_effective_date => p_effective_date) then
1639: --

Line 1657: if hr_api.not_exists_in_hr_lookups

1653: and p_dsply_on_enrt_flag is not null then
1654: --
1655: -- check if value of lookup falls within lookup type.
1656: --
1657: if hr_api.not_exists_in_hr_lookups
1658: (p_lookup_type => 'YES_NO',
1659: p_lookup_code => p_dsply_on_enrt_flag,
1660: p_effective_date => p_effective_date) then
1661: --

Line 1679: if hr_api.not_exists_in_hr_lookups

1675: and p_use_calc_acty_bs_rt_flag is not null then
1676: --
1677: -- check if value of lookup falls within lookup type.
1678: --
1679: if hr_api.not_exists_in_hr_lookups
1680: (p_lookup_type => 'YES_NO',
1681: p_lookup_code => p_use_calc_acty_bs_rt_flag,
1682: p_effective_date => p_effective_date) then
1683: --

Line 1703: if hr_api.not_exists_in_hr_lookups

1699: and p_uses_ded_sched_flag is not null then
1700: --
1701: -- check if value of lookup falls within lookup type.
1702: --
1703: if hr_api.not_exists_in_hr_lookups
1704: (p_lookup_type => 'YES_NO',
1705: p_lookup_code => p_uses_ded_sched_flag,
1706: p_effective_date => p_effective_date) then
1707: --

Line 1725: if hr_api.not_exists_in_hr_lookups

1721: and p_uses_varbl_rt_flag is not null then
1722: --
1723: -- check if value of lookup falls within lookup type.
1724: --
1725: if hr_api.not_exists_in_hr_lookups
1726: (p_lookup_type => 'YES_NO',
1727: p_lookup_code => p_uses_varbl_rt_flag,
1728: p_effective_date => p_effective_date) then
1729: --

Line 1771: if hr_api.not_exists_in_hr_lookups

1767: and p_vstg_sched_apls_fLag is not null then
1768: --
1769: -- check if value of lookup falls within lookup type.
1770: --
1771: if hr_api.not_exists_in_hr_lookups
1772: (p_lookup_type => 'YES_NO',
1773: p_lookup_code => p_vstg_sched_apls_fLag,
1774: p_effective_date => p_effective_date) then
1775: --

Line 1793: if hr_api.not_exists_in_hr_lookups

1789: and p_proc_each_pp_dflt_flag is not null then
1790: --
1791: -- check if value of lookup falls within lookup type.
1792: --
1793: if hr_api.not_exists_in_hr_lookups
1794: (p_lookup_type => 'YES_NO',
1795: p_lookup_code => p_proc_each_pp_dflt_flag,
1796: p_effective_date => p_effective_date) then
1797: --

Line 1815: if hr_api.not_exists_in_hr_lookups

1811: and p_prdct_flx_cr_when_elig_flag is not null then
1812: --
1813: -- check if value of lookup falls within lookup type.
1814: --
1815: if hr_api.not_exists_in_hr_lookups
1816: (p_lookup_type => 'YES_NO',
1817: p_lookup_code => p_prdct_flx_cr_when_elig_flag,
1818: p_effective_date => p_effective_date) then
1819: --

Line 1837: if hr_api.not_exists_in_hr_lookups

1833: and p_no_std_rt_used_flag is not null then
1834: --
1835: -- check if value of lookup falls within lookup type.
1836: --
1837: if hr_api.not_exists_in_hr_lookups
1838: (p_lookup_type => 'YES_NO',
1839: p_lookup_code => p_no_std_rt_used_flag,
1840: p_effective_date => p_effective_date) then
1841: --

Line 1866: if hr_api.not_exists_in_hr_lookups

1862: and p_uses_pymt_sched_flag is not null then
1863: --
1864: -- check if value of lookup falls within lookup type.
1865: --
1866: if hr_api.not_exists_in_hr_lookups
1867: (p_lookup_type => 'YES_NO',
1868: p_lookup_code => p_uses_pymt_sched_flag,
1869: p_effective_date => p_effective_date) then
1870: --

Line 1899: if hr_api.not_exists_in_hr_lookups

1895: and p_val_ovrid_alwd_flag is not null then
1896: --
1897: -- check if value of lookup falls within lookup type.
1898: --
1899: if hr_api.not_exists_in_hr_lookups
1900: (p_lookup_type => 'YES_NO',
1901: p_lookup_code => p_val_ovrid_alwd_flag,
1902: p_effective_date => p_effective_date) then
1903: --

Line 1921: if hr_api.not_exists_in_hr_lookups

1917: and p_no_mx_elcn_val_dfnd_flag is not null then
1918: --
1919: -- check if value of lookup falls within lookup type.
1920: --
1921: if hr_api.not_exists_in_hr_lookups
1922: (p_lookup_type => 'YES_NO',
1923: p_lookup_code => p_no_mx_elcn_val_dfnd_flag,
1924: p_effective_date => p_effective_date) then
1925: --

Line 1943: if hr_api.not_exists_in_hr_lookups

1939: and p_entr_val_at_enrt_flag is not null then
1940: --
1941: -- check if value of lookup falls within lookup type.
1942: --
1943: if hr_api.not_exists_in_hr_lookups
1944: (p_lookup_type => 'YES_NO',
1945: p_lookup_code => p_entr_val_at_enrt_flag,
1946: p_effective_date => p_effective_date) then
1947: --

Line 1965: if hr_api.not_exists_in_hr_lookups

1961: and p_entr_ann_val_flag is not null then
1962: --
1963: -- check if value of lookup falls within lookup type.
1964: --
1965: if hr_api.not_exists_in_hr_lookups
1966: (p_lookup_type => 'YES_NO',
1967: p_lookup_code => p_entr_ann_val_flag,
1968: p_effective_date => p_effective_date) then
1969: --

Line 2014: if hr_api.not_exists_in_hr_lookups

2010: and p_no_mn_elcn_val_dfnd_flag is not null then
2011: --
2012: -- check if value of lookup falls within lookup type.
2013: --
2014: if hr_api.not_exists_in_hr_lookups
2015: (p_lookup_type => 'YES_NO',
2016: p_lookup_code => p_no_mn_elcn_val_dfnd_flag,
2017: p_effective_date => p_effective_date) then
2018: --

Line 2035: if hr_api.not_exists_in_hr_lookups

2031: and p_only_one_bal_typ_alwd_flag is not null then
2032: --
2033: -- check if value of lookup falls within lookup type.
2034: --
2035: if hr_api.not_exists_in_hr_lookups
2036: (p_lookup_type => 'YES_NO',
2037: p_lookup_code => p_only_one_bal_typ_alwd_flag,
2038: p_effective_date => p_effective_date) then
2039: --

Line 2057: if hr_api.not_exists_in_hr_lookups

2053: and p_ele_rqd_flag is not null then
2054: --
2055: -- check if value of lookup falls within lookup type.
2056: --
2057: if hr_api.not_exists_in_hr_lookups
2058: (p_lookup_type => 'YES_NO',
2059: p_lookup_code => p_ele_rqd_flag,
2060: p_effective_date => p_effective_date) then
2061: --

Line 2082: if hr_api.not_exists_in_hr_lookups

2078: and p_subj_to_imptd_incm_flag is not null then
2079: --
2080: -- check if value of lookup falls within lookup type.
2081: --
2082: if hr_api.not_exists_in_hr_lookups
2083: (p_lookup_type => 'YES_NO',
2084: p_lookup_code => p_subj_to_imptd_incm_flag,
2085: p_effective_date => p_effective_date) then
2086: --

Line 2273: if hr_api.not_exists_in_hr_lookups

2269: fnd_message.set_name('BEN','BEN_93739_CWB_SACTY_NOT_NULL');
2270: fnd_message.raise_error;
2271: end if ;
2272: */
2273: if hr_api.not_exists_in_hr_lookups
2274: (p_lookup_type => 'BEN_SUB_ACTY_TYP',
2275: p_lookup_code => p_sub_acty_typ_cd ,
2276: p_effective_date => p_effective_start_date) then
2277: --

Line 2697: if hr_api.not_exists_in_hr_lookups

2693: and p_rt_usg_cd is not null then
2694: --
2695: -- check if value of lookup falls within lookup type.
2696: --
2697: if hr_api.not_exists_in_hr_lookups
2698: (p_lookup_type => 'BEN_RT_USG',
2699: p_lookup_code => p_rt_usg_cd,
2700: p_effective_date => p_effective_date) then
2701: --

Line 2719: if hr_api.not_exists_in_hr_lookups

2715: and p_prort_mn_ann_elcn_val_cd is not null then
2716: --
2717: -- check if value of lookup falls within lookup type.
2718: --
2719: if hr_api.not_exists_in_hr_lookups
2720: (p_lookup_type => 'BEN_PRORT_ANN_ELCN_VAL',
2721: p_lookup_code => p_prort_mn_ann_elcn_val_cd,
2722: p_effective_date => p_effective_date) then
2723: --

Line 2744: if hr_api.not_exists_in_hr_lookups

2740: and p_prort_mx_ann_elcn_val_cd is not null then
2741: --
2742: -- check if value of lookup falls within lookup type.
2743: --
2744: if hr_api.not_exists_in_hr_lookups
2745: (p_lookup_type => 'BEN_PRORT_ANN_ELCN_VAL',
2746: p_lookup_code => p_prort_mx_ann_elcn_val_cd,
2747: p_effective_date => p_effective_date) then
2748: --

Line 2769: if hr_api.not_exists_in_hr_lookups

2765: and p_one_ann_pymt_cd is not null then
2766: --
2767: -- check if value of lookup falls within lookup type.
2768: --
2769: if hr_api.not_exists_in_hr_lookups
2770: (p_lookup_type => 'BEN_ONE_ANN_PYMT',
2771: p_lookup_code => p_one_ann_pymt_cd,
2772: p_effective_date => p_effective_date) then
2773: --

Line 2794: if hr_api.not_exists_in_hr_lookups

2790: and p_acty_typ_cd is not null then
2791: --
2792: -- check if value of lookup falls within lookup type.
2793: --
2794: if hr_api.not_exists_in_hr_lookups
2795: (p_lookup_type => 'BEN_ACTY_TYP',
2796: p_lookup_code => p_acty_typ_cd,
2797: p_effective_date => p_effective_date) then
2798: --

Line 2825: if hr_api.not_exists_in_hr_lookups

2821: and p_rt_typ_cd is not null then
2822: --
2823: -- check if value of lookup falls within lookup type.
2824: --
2825: if hr_api.not_exists_in_hr_lookups
2826: (p_lookup_type => 'BEN_RT_TYP',
2827: p_lookup_code => p_rt_typ_cd,
2828: p_effective_date => p_effective_date) then
2829: --

Line 2847: if hr_api.not_exists_in_hr_lookups

2843: and p_bnft_rt_typ_cd is not null then
2844: --
2845: -- check if value of lookup falls within lookup type.
2846: --
2847: if hr_api.not_exists_in_hr_lookups
2848: (p_lookup_type => 'BEN_RT_TYP',
2849: p_lookup_code => p_bnft_rt_typ_cd,
2850: p_effective_date => p_effective_date) then
2851: --

Line 2870: if hr_api.not_exists_in_hr_lookups

2866: and p_tx_typ_cd is not null then
2867: --
2868: -- check if value of lookup falls within lookup type.
2869: --
2870: if hr_api.not_exists_in_hr_lookups
2871: (p_lookup_type => 'BEN_TX_TYP',
2872: p_lookup_code => p_tx_typ_cd,
2873: p_effective_date => p_effective_date) then
2874: --

Line 2893: if hr_api.not_exists_in_hr_lookups

2889: and p_parnt_chld_cd is not null then
2890: --
2891: -- check if value of lookup falls within lookup type.
2892: --
2893: if hr_api.not_exists_in_hr_lookups
2894: (p_lookup_type => 'BEN_PRNT_CHLD',
2895: p_lookup_code => p_parnt_chld_cd,
2896: p_effective_date => p_effective_date) then
2897: --

Line 2916: if hr_api.not_exists_in_hr_lookups

2912: and p_rt_mlt_cd is not null then
2913: --
2914: -- check if value of lookup falls within lookup type.
2915: --
2916: if hr_api.not_exists_in_hr_lookups
2917: (p_lookup_type => 'BEN_MLT',
2918: p_lookup_code => p_rt_mlt_cd,
2919: p_effective_date => p_effective_date) then
2920: --

Line 2947: if hr_api.not_exists_in_hr_lookups

2943: and p_rcrrg_cd is not null then
2944: --
2945: -- check if value of lookup falls within lookup type.
2946: --
2947: if hr_api.not_exists_in_hr_lookups
2948: (p_lookup_type => 'BEN_RCRRG',
2949: p_lookup_code => p_rcrrg_cd,
2950: p_effective_date => p_effective_date) then
2951: --

Line 2970: if hr_api.not_exists_in_hr_lookups

2966: and p_rndg_cd is not null then
2967: --
2968: -- check if value of lookup falls within lookup type.
2969: --
2970: if hr_api.not_exists_in_hr_lookups
2971: (p_lookup_type => 'BEN_RNDG',
2972: p_lookup_code => p_rndg_cd,
2973: p_effective_date => p_effective_date) then
2974: --

Line 2993: if hr_api.not_exists_in_hr_lookups

2989: and p_prtl_mo_det_mthd_cd is not null then
2990: --
2991: -- check if value of lookup falls within lookup type.
2992: --
2993: if hr_api.not_exists_in_hr_lookups
2994: (p_lookup_type => 'BEN_PRTL_MO_DET_MTHD',
2995: p_lookup_code => p_prtl_mo_det_mthd_cd,
2996: p_effective_date => p_effective_date) then
2997: --

Line 3016: if hr_api.not_exists_in_hr_lookups

3012: and p_acty_base_rt_stat_cd is not null then
3013: --
3014: -- check if value of lookup falls within lookup type.
3015: --
3016: if hr_api.not_exists_in_hr_lookups
3017: (p_lookup_type => 'BEN_STAT',
3018: p_lookup_code => p_acty_base_rt_stat_cd,
3019: p_effective_date => p_effective_date) then
3020: --

Line 3039: if hr_api.not_exists_in_hr_lookups

3035: and p_procg_src_cd is not null then
3036: --
3037: -- check if value of lookup falls within lookup type.
3038: --
3039: if hr_api.not_exists_in_hr_lookups
3040: (p_lookup_type => 'BEN_PROCG_SRC',
3041: p_lookup_code => p_procg_src_cd,
3042: p_effective_date => p_effective_date) then
3043: --

Line 3062: if hr_api.not_exists_in_hr_lookups

3058: and p_frgn_erg_ded_typ_cd is not null then
3059: --
3060: -- check if value of lookup falls within lookup type.
3061: --
3062: if hr_api.not_exists_in_hr_lookups
3063: (p_lookup_type => 'BEN_ERG_DED',
3064: p_lookup_code => p_frgn_erg_ded_typ_cd,
3065: p_effective_date => p_effective_date) then
3066: --

Line 3085: if hr_api.not_exists_in_hr_lookups

3081: and p_prtl_mo_eff_dt_det_cd is not null then
3082: --
3083: -- check if value of lookup falls within lookup type.
3084: --
3085: if hr_api.not_exists_in_hr_lookups
3086: (p_lookup_type => 'BEN_PRTL_MO_EFF_DT_DET',
3087: p_lookup_code => p_prtl_mo_eff_dt_det_cd,
3088: p_effective_date => p_effective_date) then
3089: --

Line 3107: if hr_api.not_exists_in_hr_lookups

3103: and p_det_pl_ytd_cntrs_cd is not null then
3104: --
3105: -- check if value of lookup falls within lookup type.
3106: --
3107: if hr_api.not_exists_in_hr_lookups
3108: (p_lookup_type => 'BEN_DET_PL_YTD_CNTRS',
3109: p_lookup_code => p_det_pl_ytd_cntrs_cd,
3110: p_effective_date => p_effective_date) then
3111: --

Line 3132: if hr_api.not_exists_in_hr_lookups

3128: and p_asmt_to_use_cd is not null then
3129: --
3130: -- check if value of lookup falls within lookup type.
3131: --
3132: if hr_api.not_exists_in_hr_lookups
3133: (p_lookup_type => 'BEN_ASMT_TO_USE',
3134: p_lookup_code => p_asmt_to_use_cd,
3135: p_effective_date => p_effective_date) then
3136: --

Line 3157: if hr_api.not_exists_in_hr_lookups

3153: and p_currency_det_cd is not null then
3154: --
3155: -- check if value of lookup falls within lookup type.
3156: --
3157: if hr_api.not_exists_in_hr_lookups
3158: (p_lookup_type => 'BEN_CUR_DET',
3159: p_lookup_code => p_currency_det_cd,
3160: p_effective_date => p_effective_date) then
3161: --

Line 3891: if hr_api.not_exists_in_hr_lookups

3887: --
3888: fetch c1 into l_dummy;
3889: if c1%notfound then
3890: --
3891: if hr_api.not_exists_in_hr_lookups
3892: (p_lookup_type => 'BEN_NNMNTRY_UOM',
3893: p_lookup_code => p_nnmntry_uom,
3894: p_effective_date => p_effective_date) then
3895: --

Line 4041: l_acty_typ_meaning hr_lookups.meaning%type;

4037: --
4038: l_proc varchar2(72) := g_package||'chk_cwb_acty_typ_cd_unique';
4039: l_api_updating boolean;
4040: l_dummy varchar2(1);
4041: l_acty_typ_meaning hr_lookups.meaning%type;
4042: --
4043: cursor c1 is
4044: select null
4045: from ben_acty_base_rt abr