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_PGM_BUS dependencies on HR_LOOKUPS

Line 532: if hr_api.not_exists_in_hr_lookups

528: --
529: -- check if value of lookup falls within lookup type.
530: --
531:
532: if hr_api.not_exists_in_hr_lookups
533: (p_lookup_type => 'BEN_FMLY_MMBR',
534: p_lookup_code => p_vrfy_fmly_mmbr_cd,
535: p_effective_date => p_effective_date) then
536: --

Line 1224: if hr_api.not_exists_in_hr_lookups

1220: and p_dpnt_adrs_rqd_flag is not null then
1221: --
1222: -- check if value of lookup falls within lookup type.
1223: --
1224: if hr_api.not_exists_in_hr_lookups
1225: (p_lookup_type => 'YES_NO',
1226: p_lookup_code => p_dpnt_adrs_rqd_flag,
1227: p_effective_date => p_effective_date) then
1228: --

Line 1295: if hr_api.not_exists_in_hr_lookups

1291: and p_elig_apls_to_all_pls_flag is not null then
1292: --
1293: -- check if value of lookup falls within lookup type.
1294: --
1295: if hr_api.not_exists_in_hr_lookups
1296: (p_lookup_type => 'YES_NO',
1297: p_lookup_code => p_elig_apls_to_all_pls_flag,
1298: p_effective_date => p_effective_date) then
1299: --

Line 1366: if hr_api.not_exists_in_hr_lookups

1362: and p_dpnt_dob_rqd_flag is not null then
1363: --
1364: -- check if value of lookup falls within lookup type.
1365: --
1366: if hr_api.not_exists_in_hr_lookups
1367: (p_lookup_type => 'YES_NO',
1368: p_lookup_code => p_dpnt_dob_rqd_flag,
1369: p_effective_date => p_effective_date) then
1370: --

Line 1436: if hr_api.not_exists_in_hr_lookups

1432: and p_pgm_prvds_no_auto_enrt_flag is not null then
1433: --
1434: -- check if value of lookup falls within lookup type.
1435: --
1436: if hr_api.not_exists_in_hr_lookups
1437: (p_lookup_type => 'YES_NO',
1438: p_lookup_code => p_pgm_prvds_no_auto_enrt_flag,
1439: p_effective_date => p_effective_date) then
1440: --

Line 1506: if hr_api.not_exists_in_hr_lookups

1502: and p_pgm_prvds_no_dflt_enrt_flag is not null then
1503: --
1504: -- check if value of lookup falls within lookup type.
1505: --
1506: if hr_api.not_exists_in_hr_lookups
1507: (p_lookup_type => 'YES_NO',
1508: p_lookup_code => p_pgm_prvds_no_dflt_enrt_flag,
1509: p_effective_date => p_effective_date) then
1510: --

Line 1576: if hr_api.not_exists_in_hr_lookups

1572: and p_dpnt_legv_id_rqd_flag is not null then
1573: --
1574: -- check if value of lookup falls within lookup type.
1575: --
1576: if hr_api.not_exists_in_hr_lookups
1577: (p_lookup_type => 'YES_NO',
1578: p_lookup_code => p_dpnt_legv_id_rqd_flag,
1579: p_effective_date => p_effective_date) then
1580: --

Line 1646: if hr_api.not_exists_in_hr_lookups

1642: and p_elig_apls_flag 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 => 'YES_NO',
1648: p_lookup_code => p_elig_apls_flag,
1649: p_effective_date => p_effective_date) then
1650: --

Line 1716: if hr_api.not_exists_in_hr_lookups

1712: and p_uses_all_asmts_for_rts_flag is not null then
1713: --
1714: -- check if value of lookup falls within lookup type.
1715: --
1716: if hr_api.not_exists_in_hr_lookups
1717: (p_lookup_type => 'YES_NO',
1718: p_lookup_code => p_uses_all_asmts_for_rts_flag,
1719: p_effective_date => p_effective_date) then
1720: --

Line 1786: if hr_api.not_exists_in_hr_lookups

1782: and p_prtn_elig_ovrid_alwd_flag is not null then
1783: --
1784: -- check if value of lookup falls within lookup type.
1785: --
1786: if hr_api.not_exists_in_hr_lookups
1787: (p_lookup_type => 'YES_NO',
1788: p_lookup_code => p_prtn_elig_ovrid_alwd_flag,
1789: p_effective_date => p_effective_date) then
1790: --

Line 1858: if hr_api.not_exists_in_hr_lookups

1854: and p_tmprl_fctr_apls_rts_flag is not null then
1855: --
1856: -- check if value of lookup falls within lookup type.
1857: --
1858: if hr_api.not_exists_in_hr_lookups
1859: (p_lookup_type => 'YES_NO',
1860: p_lookup_code => p_tmprl_fctr_apls_rts_flag,
1861: p_effective_date => p_effective_date) then
1862: --

Line 1929: if hr_api.not_exists_in_hr_lookups

1925: and p_pgm_use_all_asnts_elig_flag is not null then
1926: --
1927: -- check if value of lookup falls within lookup type.
1928: --
1929: if hr_api.not_exists_in_hr_lookups
1930: (p_lookup_type => 'YES_NO',
1931: p_lookup_code => p_pgm_use_all_asnts_elig_flag,
1932: p_effective_date => p_effective_date) then
1933: --

Line 2000: if hr_api.not_exists_in_hr_lookups

1996: and p_coord_cvg_for_all_pls_flg is not null then
1997: --
1998: -- check if value of lookup falls within lookup type.
1999: --
2000: if hr_api.not_exists_in_hr_lookups
2001: (p_lookup_type => 'YES_NO',
2002: p_lookup_code => p_coord_cvg_for_all_pls_flg,
2003: p_effective_date => p_effective_date) then
2004: --

Line 2071: if hr_api.not_exists_in_hr_lookups

2067: and p_drvbl_fctr_dpnt_elig_flag is not null then
2068: --
2069: -- check if value of lookup falls within lookup type.
2070: --
2071: if hr_api.not_exists_in_hr_lookups
2072: (p_lookup_type => 'YES_NO',
2073: p_lookup_code => p_drvbl_fctr_dpnt_elig_flag,
2074: p_effective_date => p_effective_date) then
2075: --

Line 2143: if hr_api.not_exists_in_hr_lookups

2139: and p_mt_one_dpnt_cvg_elig_flag is not null then
2140: --
2141: -- check if value of lookup falls within lookup type.
2142: --
2143: if hr_api.not_exists_in_hr_lookups
2144: (p_lookup_type => 'YES_NO',
2145: p_lookup_code => p_mt_one_dpnt_cvg_elig_flag,
2146: p_effective_date => p_effective_date) then
2147: --

Line 2214: if hr_api.not_exists_in_hr_lookups

2210: and p_drvbl_fctr_prtn_elig_flag is not null then
2211: --
2212: -- check if value of lookup falls within lookup type.
2213: --
2214: if hr_api.not_exists_in_hr_lookups
2215: (p_lookup_type => 'YES_NO',
2216: p_lookup_code => p_drvbl_fctr_prtn_elig_flag,
2217: p_effective_date => p_effective_date) then
2218: --

Line 2287: if hr_api.not_exists_in_hr_lookups

2283: and p_alws_unrstrctd_enrt_flag is not null then
2284: --
2285: -- check if value of lookup falls within lookup type.
2286: --
2287: if hr_api.not_exists_in_hr_lookups
2288: (p_lookup_type => 'YES_NO',
2289: p_lookup_code => p_alws_unrstrctd_enrt_flag,
2290: p_effective_date => p_effective_date) then
2291: --

Line 2357: if hr_api.not_exists_in_hr_lookups

2353: and p_drvbl_fctr_apls_rts_flag is not null then
2354: --
2355: -- check if value of lookup falls within lookup type.
2356: --
2357: if hr_api.not_exists_in_hr_lookups
2358: (p_lookup_type => 'YES_NO',
2359: p_lookup_code => p_drvbl_fctr_apls_rts_flag,
2360: p_effective_date => p_effective_date) then
2361: --

Line 2429: if hr_api.not_exists_in_hr_lookups

2425: and p_tmprl_fctr_dpnt_elig_flag is not null then
2426: --
2427: -- check if value of lookup falls within lookup type.
2428: --
2429: if hr_api.not_exists_in_hr_lookups
2430: (p_lookup_type => 'YES_NO',
2431: p_lookup_code => p_tmprl_fctr_dpnt_elig_flag,
2432: p_effective_date => p_effective_date) then
2433: --

Line 2500: if hr_api.not_exists_in_hr_lookups

2496: and p_tmprl_fctr_prtn_elig_flag is not null then
2497: --
2498: -- check if value of lookup falls within lookup type.
2499: --
2500: if hr_api.not_exists_in_hr_lookups
2501: (p_lookup_type => 'YES_NO',
2502: p_lookup_code => p_tmprl_fctr_prtn_elig_flag,
2503: p_effective_date => p_effective_date) then
2504: --

Line 2571: if hr_api.not_exists_in_hr_lookups

2567: and p_dpnt_dsgn_no_ctfn_rqd_flag is not null then
2568: --
2569: -- check if value of lookup falls within lookup type.
2570: --
2571: if hr_api.not_exists_in_hr_lookups
2572: (p_lookup_type => 'YES_NO',
2573: p_lookup_code => p_dpnt_dsgn_no_ctfn_rqd_flag,
2574: p_effective_date => p_effective_date) then
2575: --

Line 2642: if hr_api.not_exists_in_hr_lookups

2638: and p_trk_inelig_per_flag is not null then
2639: --
2640: -- check if value of lookup falls within lookup type.
2641: --
2642: if hr_api.not_exists_in_hr_lookups
2643: (p_lookup_type => 'YES_NO',
2644: p_lookup_code => p_trk_inelig_per_flag,
2645: p_effective_date => p_effective_date) then
2646: --

Line 2695: from hr_lookups

2691: is
2692: l_proc varchar2(72) := g_package||'chk_pgm_stat_cd_not_null';
2693: l_pgm_stat varchar2(30);
2694: cursor c1 is select lookup_code
2695: from hr_lookups
2696: where lookup_type = 'BEN_STAT'
2697: and p_effective_date between start_date_active
2698: and end_date_active
2699: and enabled_flag = 'Y';

Line 2926: if hr_api.not_exists_in_hr_lookups

2922: --
2923: -- check if value of lookup falls within lookup type.
2924: --
2925: --
2926: if hr_api.not_exists_in_hr_lookups
2927: (p_lookup_type => 'BEN_ENRT_MTHD',
2928: p_lookup_code => p_enrt_mthd_cd,
2929: p_effective_date => p_effective_date) then
2930: --

Line 2998: if hr_api.not_exists_in_hr_lookups

2994: --
2995: -- check if value of lookup falls within lookup type.
2996: --
2997: --
2998: if hr_api.not_exists_in_hr_lookups
2999: (p_lookup_type => 'BEN_POE_LVL',
3000: p_lookup_code => p_poe_lvl_cd,
3001: p_effective_date => p_effective_date) then
3002: --

Line 3071: if hr_api.not_exists_in_hr_lookups

3067: --
3068: -- check if value of lookup falls within lookup type.
3069: --
3070: --
3071: if hr_api.not_exists_in_hr_lookups
3072: (p_lookup_type => 'BEN_ENRT',
3073: p_lookup_code => p_enrt_cd,
3074: p_effective_date => p_effective_date) then
3075: --

Line 3141: if hr_api.not_exists_in_hr_lookups

3137: --
3138: -- check if value of lookup falls within lookup type.
3139: --
3140: --
3141: if hr_api.not_exists_in_hr_lookups
3142: (p_lookup_type => 'BEN_STAT',
3143: p_lookup_code => p_pgm_stat_cd,
3144: p_effective_date => p_effective_date) then
3145: --

Line 3211: if hr_api.not_exists_in_hr_lookups

3207: -- check if value of lookup falls within lookup type.
3208: --
3209: --
3210: if p_dpnt_dsgn_lvl_cd is not null then
3211: if hr_api.not_exists_in_hr_lookups
3212: (p_lookup_type => 'BEN_DPNT_DSGN_LVL',
3213: p_lookup_code => p_dpnt_dsgn_lvl_cd,
3214: p_effective_date => p_effective_date) then
3215: --

Line 3280: if hr_api.not_exists_in_hr_lookups

3276: or not l_api_updating) then
3277: --
3278: -- check if value of lookup falls within lookup type.
3279: --
3280: if hr_api.not_exists_in_hr_lookups
3281: (p_lookup_type => 'BEN_PGM_TYP',
3282: p_lookup_code => p_pgm_typ_cd,
3283: p_effective_date => p_effective_date) then
3284: --

Line 3358: if hr_api.not_exists_in_hr_lookups

3354: -- check if value of lookup falls within lookup type.
3355: --
3356: --
3357: if p_dpnt_dsgn_cd is not null then
3358: if hr_api.not_exists_in_hr_lookups
3359: (p_lookup_type => 'BEN_DPNT_DSGN',
3360: p_lookup_code => p_dpnt_dsgn_cd,
3361: p_effective_date => p_effective_date) then
3362: --

Line 3449: if hr_api.not_exists_in_hr_lookups

3445: -- check if value of lookup falls within lookup type.
3446: --
3447: --
3448: if p_pgm_grp_cd is not null then
3449: if hr_api.not_exists_in_hr_lookups
3450: (p_lookup_type => 'BEN_PGM_GRP',
3451: p_lookup_code => p_pgm_grp_cd,
3452: p_effective_date => p_effective_date) then
3453: --

Line 3520: if hr_api.not_exists_in_hr_lookups

3516: -- check if value of lookup falls within lookup type.
3517: --
3518: --
3519: if p_acty_ref_perd_cd is not null then
3520: if hr_api.not_exists_in_hr_lookups
3521: (p_lookup_type => 'BEN_ACTY_REF_PERD',
3522: p_lookup_code => p_acty_ref_perd_cd,
3523: p_effective_date => p_effective_date) then
3524: --

Line 3591: if hr_api.not_exists_in_hr_lookups

3587: -- check if value of lookup falls within lookup type.
3588: --
3589: --
3590: if p_enrt_cvg_strt_dt_cd is not null then
3591: if hr_api.not_exists_in_hr_lookups
3592: (p_lookup_type => 'BEN_ENRT_CVG_STRT',
3593: p_lookup_code => p_enrt_cvg_strt_dt_cd,
3594: p_effective_date => p_effective_date) then
3595: --

Line 3662: if hr_api.not_exists_in_hr_lookups

3658: -- check if value of lookup falls within lookup type.
3659: --
3660: --
3661: if p_enrt_cvg_end_dt_cd is not null then
3662: if hr_api.not_exists_in_hr_lookups
3663: (p_lookup_type => 'BEN_ENRT_CVG_END',
3664: p_lookup_code => p_enrt_cvg_end_dt_cd,
3665: p_effective_date => p_effective_date) then
3666: --

Line 3734: if hr_api.not_exists_in_hr_lookups

3730: -- check if value of lookup falls within lookup type.
3731: --
3732: --
3733: if p_prtn_strt_dt_cd is not null then
3734: if hr_api.not_exists_in_hr_lookups
3735: (p_lookup_type => 'BEN_PRTN_ELIG_STRT',
3736: p_lookup_code => p_prtn_strt_dt_cd,
3737: p_effective_date => p_effective_date) then
3738: --

Line 3805: if hr_api.not_exists_in_hr_lookups

3801: -- check if value of lookup falls within lookup type.
3802: --
3803: --
3804: if p_prtn_end_dt_cd is not null then
3805: if hr_api.not_exists_in_hr_lookups
3806: (p_lookup_type => 'BEN_PRTN_ELIG_END',
3807: p_lookup_code => p_prtn_end_dt_cd,
3808: p_effective_date => p_effective_date) then
3809: --

Line 4081: if hr_api.not_exists_in_hr_lookups

4077: -- check if value of lookup falls within lookup type.
4078: --
4079: --
4080: if p_Dflt_step_cd is not null then
4081: if hr_api.not_exists_in_hr_lookups
4082: (p_lookup_type => 'BEN_GL_PROG_STYLE',
4083: p_lookup_code => p_dflt_step_cd,
4084: p_effective_date => p_effective_date) then
4085: --

Line 4109: if hr_api.not_exists_in_hr_lookups

4105: -- check if value of lookup falls within lookup type.
4106: --
4107: --
4108: if p_Update_salary_cd is not null then
4109: if hr_api.not_exists_in_hr_lookups
4110: (p_lookup_type => 'PQH_GSP_SAL_UPD_MTHD',
4111: p_lookup_code => p_Update_salary_cd,
4112: p_effective_date => p_effective_date) then
4113: --

Line 4136: if hr_api.not_exists_in_hr_lookups

4132: -- check if value of lookup falls within lookup type.
4133: --
4134: --
4135: if p_Scores_calc_mthd_cd is not null then
4136: if hr_api.not_exists_in_hr_lookups
4137: (p_lookup_type => 'BEN_SCORES_CALC_MTHD',
4138: p_lookup_code => p_Scores_calc_mthd_cd,
4139: p_effective_date => p_effective_date) then
4140: --

Line 4164: if hr_api.not_exists_in_hr_lookups

4160: -- check if value of lookup falls within lookup type.
4161: --
4162: --
4163: if p_Scores_calc_mthd_cd is not null then
4164: if hr_api.not_exists_in_hr_lookups
4165: (p_lookup_type => 'PQH_GSP_SAL_CALC_METH',
4166: p_lookup_code => p_salary_calc_mthd_cd,
4167: p_effective_date => p_effective_date) then
4168: --

Line 4240: if hr_api.not_exists_in_hr_lookups

4236: -- check if value of lookup falls within lookup type.
4237: --
4238: --
4239: if p_enrt_info_rt_freq_cd is not null then
4240: if hr_api.not_exists_in_hr_lookups
4241: (p_lookup_type => 'BEN_ENRT_INFO_RT_FREQ',
4242: p_lookup_code => p_enrt_info_rt_freq_cd,
4243: p_effective_date => p_effective_date) then
4244: --

Line 4311: if hr_api.not_exists_in_hr_lookups

4307: -- check if value of lookup falls within lookup type.
4308: --
4309: --
4310: if p_dpnt_cvg_strt_dt_cd is not null then
4311: if hr_api.not_exists_in_hr_lookups
4312: (p_lookup_type => 'BEN_DPNT_CVG_STRT',
4313: p_lookup_code => p_dpnt_cvg_strt_dt_cd,
4314: p_effective_date => p_effective_date) then
4315: --

Line 4382: if hr_api.not_exists_in_hr_lookups

4378: -- check if value of lookup falls within lookup type.
4379: --
4380: --
4381: if p_dpnt_cvg_end_dt_cd is not null then
4382: if hr_api.not_exists_in_hr_lookups
4383: (p_lookup_type => 'BEN_DPNT_CVG_END',
4384: p_lookup_code => p_dpnt_cvg_end_dt_cd,
4385: p_effective_date => p_effective_date) then
4386: --