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_EVALUATE_ELIG_PROFILES dependencies on HR_API

Line 462: nvl(l_prtn_ovridn_thru_dt,hr_api.g_eot) > nvl(l_fonm_cvg_strt_dt,p_effective_date))

458: --
459: if not p_comp_obj_mode or
460: (p_eval_typ <> 'E' and
461: not (nvl(l_prtn_ovridn_flag,'N') = 'Y' and
462: nvl(l_prtn_ovridn_thru_dt,hr_api.g_eot) > nvl(l_fonm_cvg_strt_dt,p_effective_date))
463: ) then
464: --
465: ben_derive_factors.determine_los
466: (p_person_id => p_person_id

Line 670: nvl(l_prtn_ovridn_thru_dt,hr_api.g_eot) > nvl(l_fonm_cvg_strt_dt,p_effective_date))

666: --
667: if not p_comp_obj_mode or
668: (p_eval_typ <> 'E' and
669: not (nvl(l_prtn_ovridn_flag,'N') = 'Y' and
670: nvl(l_prtn_ovridn_thru_dt,hr_api.g_eot) > nvl(l_fonm_cvg_strt_dt,p_effective_date))
671: ) then
672: --
673: ben_derive_factors.determine_age
674: (p_person_id => p_person_id

Line 884: nvl(l_prtn_ovridn_thru_dt,hr_api.g_eot) > nvl(l_fonm_cvg_strt_dt,p_effective_date))

880: --
881: if not p_comp_obj_mode or
882: (p_eval_typ <> 'E' and
883: not (nvl(l_prtn_ovridn_flag,'N') = 'Y' and
884: nvl(l_prtn_ovridn_thru_dt,hr_api.g_eot) > nvl(l_fonm_cvg_strt_dt,p_effective_date))
885: ) then
886: --
887: ben_derive_factors.determine_los
888: (p_person_id => p_person_id,

Line 6520: and pdp.effective_end_date = hr_api.g_eot;

6516: and pen.prtt_enrt_rslt_stat_cd is null
6517: and l_date_to_use
6518: between pdp.cvg_strt_dt
6519: and pdp.cvg_thru_dt
6520: and pdp.effective_end_date = hr_api.g_eot;
6521: --
6522: begin
6523: --
6524: hr_utility.set_location('Entering: '||l_proc, 10);

Line 6767: and pdp.effective_end_date = hr_api.g_eot;

6763: and pdp.business_group_id = pen.business_group_id
6764: and p_date_to_use
6765: between pdp.cvg_strt_dt
6766: and pdp.cvg_thru_dt
6767: and pdp.effective_end_date = hr_api.g_eot;
6768: --
6769: begin
6770: --
6771: hr_utility.set_location('Entering: '||l_proc, 10);

Line 7082: and pdp.effective_end_date = hr_api.g_eot;

7078: and pdp.business_group_id = pen.business_group_id
7079: and p_date_to_use
7080: between pdp.cvg_strt_dt
7081: and pdp.cvg_thru_dt
7082: and pdp.effective_end_date = hr_api.g_eot;
7083: --
7084: cursor c2(p_pl_id in number,p_date_to_use date ) is
7085: select null
7086: from ben_pl_regn_f prg

Line 7234: and pdp.effective_end_date = hr_api.g_eot;

7230: and pen.prtt_enrt_rslt_stat_cd is null
7231: and l_date_to_use -- 5550851
7232: between pdp.cvg_strt_dt
7233: and pdp.cvg_thru_dt
7234: and pdp.effective_end_date = hr_api.g_eot;
7235: --
7236: begin
7237: --
7238: hr_utility.set_location('Entering: '||l_proc, 10);

Line 7663: l_eot date := hr_api.g_eot;

7659: --
7660: l_ttl_cvg_vol number ;
7661: l_dummy char;
7662: --
7663: l_eot date := hr_api.g_eot;
7664: --
7665: cursor c_bnft_amt(cp_lf_evt_ocrd_dt in date ,
7666: cp_effective_date in date ,
7667: cp_business_group_id in number) is

Line 7800: l_eot date := hr_api.g_eot;

7796: --
7797: l_ttl_prtt number ;
7798: l_dummy char;
7799: --
7800: l_eot date := hr_api.g_eot;
7801: --
7802: cursor c_ttl_prtt(cp_lf_evt_ocrd_dt in date ,
7803: cp_effective_date in date ,
7804: cp_business_group_id in number) is

Line 7935: l_eot date := hr_api.g_eot;

7931: l_ele_num pls_integer;
7932: --
7933: l_dummy char ;
7934: --
7935: l_eot date := hr_api.g_eot;
7936: --
7937: cursor c_prtt_in_pl(cp_person_id in number,
7938: cp_pl_id in number,
7939: cp_lf_evt_ocrd_dt in date ,

Line 8045: l_eot date := hr_api.g_eot;

8041: l_ele_num pls_integer;
8042: --
8043: l_dummy char ;
8044: --
8045: l_eot date := hr_api.g_eot;
8046: --
8047: cursor c_prtt_in_oipl(cp_person_id in number,
8048: cp_pl_typ_opt_typ_id in number,
8049: cp_oipl_id in number,

Line 9975: hr_api.return_legislation_code(p_business_group_id) = 'US'

9971: (p_soft_coding_keyflex_id => l_ass_rec.soft_coding_keyflex_id,
9972: p_rec => l_hsc_rec);
9973: --
9974: if l_hsc_rec.segment1 is not null and
9975: hr_api.return_legislation_code(p_business_group_id) = 'US'
9976: then
9977: --
9978: ben_org_object.get_object
9979: (p_organization_id => l_hsc_rec.segment1,

Line 9987: and hr_api.return_legislation_code(p_business_group_id) = 'US'

9983: --
9984: end if;
9985: --
9986: if l_eligprof_dets(l_elptorrw_num).elig_lgl_enty_flag = 'Y'
9987: and hr_api.return_legislation_code(p_business_group_id) = 'US'
9988: then
9989: check_lgl_enty_elig
9990: (p_eligy_prfl_id => l_eligprof_dets(l_elptorrw_num).
9991: eligy_prfl_id,

Line 10123: nvl(p_asg_status,hr_api.g_varchar2) <> 'TERM_ASSIGN' then

10119: --
10120: hr_utility.set_location(' here 3 ',999);
10121: if p_person_id is not null and
10122: l_typ_rec(1).system_person_type = 'EMP' and
10123: nvl(p_asg_status,hr_api.g_varchar2) <> 'TERM_ASSIGN' then
10124:
10125: hr_utility.set_location(l_proc||' Not TERM ASSIGN',48);
10126:
10127: if l_eligprof_dets(l_elptorrw_num).elig_pct_fl_tm_flag = 'Y' then