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_EXT_EVALUATE_INCLUSION dependencies on BEN_EXT_PERSON

Line 757: ben_ext_person.g_effective_date,

753: if p_oper_cd = 'BE' then
754: if p_crit_typ_cd = 'CAD' then
755: l_actl_dt_1 := trunc(ben_ext_util.calc_ext_date
756: (p_val1,
757: ben_ext_person.g_effective_date,
758: ben_ext_thread.g_ext_dfn_id)
759: );
760: l_actl_dt_2 := trunc(ben_ext_util.calc_ext_date
761: (p_val2,

Line 762: ben_ext_person.g_effective_date,

758: ben_ext_thread.g_ext_dfn_id)
759: );
760: l_actl_dt_2 := trunc(ben_ext_util.calc_ext_date
761: (p_val2,
762: ben_ext_person.g_effective_date,
763: ben_ext_thread.g_ext_dfn_id)
764: );
765: if trunc(p_actl_dt) >= l_actl_dt_1 and trunc(p_actl_dt) <= l_actl_dt_2 then
766: l_success := 'Y';

Line 773: ben_ext_person.g_effective_date,

769: end if;
770: elsif p_crit_typ_cd = 'CED' then
771: l_eff_dt_1 := trunc(ben_ext_util.calc_ext_date
772: (p_val1,
773: ben_ext_person.g_effective_date,
774: ben_ext_thread.g_ext_dfn_id)
775: );
776: l_eff_dt_2 := trunc(ben_ext_util.calc_ext_date
777: (p_val2,

Line 778: ben_ext_person.g_effective_date,

774: ben_ext_thread.g_ext_dfn_id)
775: );
776: l_eff_dt_2 := trunc(ben_ext_util.calc_ext_date
777: (p_val2,
778: ben_ext_person.g_effective_date,
779: ben_ext_thread.g_ext_dfn_id)
780: );
781: if trunc(p_eff_dt) >= l_eff_dt_1 and trunc(p_eff_dt) <= l_eff_dt_2 then
782: l_success := 'Y';

Line 799: ben_ext_person.g_effective_date,

795: end if;
796: elsif p_crit_typ_cd = 'CAD' then
797: l_actl_dt_1 := trunc(ben_ext_util.calc_ext_date
798: (p_val1,
799: ben_ext_person.g_effective_date,
800: ben_ext_thread.g_ext_dfn_id)
801: );
802: if trunc(p_actl_dt) = l_actl_dt_1 then
803: l_success := 'Y';

Line 810: ben_ext_person.g_effective_date,

806: end if;
807: elsif p_crit_typ_cd = 'CED' then
808: l_eff_dt_1 := trunc(ben_ext_util.calc_ext_date
809: (p_val1,
810: ben_ext_person.g_effective_date,
811: ben_ext_thread.g_ext_dfn_id)
812: );
813: if trunc(p_eff_dt) = l_eff_dt_1 then
814: l_success := 'Y';

Line 1115: and ben_ext_person.g_benefits_ext_dt between rg.effective_start_date

1111: ben_ext_crit_val xcv
1112: WHERE to_char(rg.rptg_grp_id) = xcv.val_1
1113: and xcv.ext_crit_typ_id = p_crit_typ_id
1114: and rg.pl_id is not null
1115: and ben_ext_person.g_benefits_ext_dt between rg.effective_start_date
1116: and rg.effective_end_date;
1117: --
1118: l_val_1 ben_popl_rptg_grp_f.pl_id%type;
1119: l_proc varchar2(72);

Line 1553: ben_ext_person.g_pay_last_start_date := ben_ext_util.calc_ext_date

1549: g_payroll_last_dt_list2) ;
1550:
1551: ---intilise the gloabl variable
1552: if g_payroll_last_dt_list1.count > 0 and g_payroll_last_dt_list2.count > 0 then
1553: ben_ext_person.g_pay_last_start_date := ben_ext_util.calc_ext_date
1554: (p_ext_date_cd => g_payroll_last_dt_list1(1),
1555: p_abs_date => ben_extract.g_effective_date,
1556: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
1557:

Line 1558: ben_ext_person.g_pay_last_end_date := ben_ext_util.calc_ext_date

1554: (p_ext_date_cd => g_payroll_last_dt_list1(1),
1555: p_abs_date => ben_extract.g_effective_date,
1556: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
1557:
1558: ben_ext_person.g_pay_last_end_date := ben_ext_util.calc_ext_date
1559: (p_ext_date_cd => g_payroll_last_dt_list2(1),
1560: p_abs_date => ben_extract.g_effective_date,
1561: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
1562:

Line 1820: and asn.assignment_id = ben_ext_person.g_assignment_id --1969853

1816: cursor get_org_id is
1817: SELECT organization_id
1818: FROM per_all_assignments_f asn
1819: WHERE asn.person_id = p_person_id
1820: and asn.assignment_id = ben_ext_person.g_assignment_id --1969853
1821: AND asn.primary_flag = 'Y'
1822: AND p_effective_date between effective_start_date
1823: and effective_end_date;
1824: --

Line 1890: and asn.assignment_id = ben_ext_person.g_assignment_id --1969853

1886: cursor get_loc_id is
1887: SELECT location_id
1888: FROM per_all_assignments_f asn
1889: WHERE asn.person_id = p_person_id
1890: and asn.assignment_id = ben_ext_person.g_assignment_id --1969853
1891: AND asn.primary_flag = 'Y'
1892: AND p_effective_date between effective_start_date
1893: and effective_end_date;
1894: --

Line 1959: and asn.assignment_id = ben_ext_person.g_assignment_id --1969853

1955: cursor get_gre is
1956: SELECT flex.segment1
1957: FROM per_all_assignments_f asn, hr_soft_coding_keyflex flex
1958: WHERE asn.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
1959: and asn.assignment_id = ben_ext_person.g_assignment_id --1969853
1960: AND asn.person_id = p_person_id
1961: AND asn.primary_flag = 'Y'
1962: AND p_effective_date between asn.effective_start_date
1963: and asn.effective_end_date

Line 2169: and asn.assignment_id = ben_ext_person.g_assignment_id --1969853

2165: cursor get_ee_status is
2166: SELECT assignment_status_type_id
2167: FROM per_all_assignments_f asn
2168: WHERE asn.person_id = p_person_id
2169: and asn.assignment_id = ben_ext_person.g_assignment_id --1969853
2170: AND asn.primary_flag = 'Y'
2171: AND p_effective_date between effective_start_date and effective_end_date;
2172: --
2173: l_ee_status per_all_assignments_f.assignment_status_type_id%type;

Line 2237: and asn.assignment_id = ben_ext_person.g_assignment_id --1969853

2233: cursor c_pay is
2234: SELECT payroll_id
2235: FROM per_all_assignments_f asn
2236: WHERE asn.person_id = p_person_id
2237: and asn.assignment_id = ben_ext_person.g_assignment_id --1969853
2238: AND asn.primary_flag = 'Y'
2239: AND p_effective_date between effective_start_date and effective_end_date;
2240: --
2241: l_payroll_id per_all_assignments_f.payroll_id%type;

Line 2304: and asg.assignment_id = ben_ext_person.g_assignment_id --1969853

2300: cursor c_asg is
2301: SELECT asg.assignment_id, asg.business_group_id
2302: FROM per_all_assignments_f asg
2303: WHERE asg.person_id = p_person_id
2304: and asg.assignment_id = ben_ext_person.g_assignment_id --1969853
2305: AND (asg.primary_flag = 'Y' or asg.assignment_type = 'A' ) -- if the asg type is A dont validate the primary flag
2306: AND p_effective_date between asg.effective_start_date
2307: and asg.effective_end_date
2308: order by decode(asg.primary_flag , 'Y', 1, 2) ;

Line 3467: if p_dpnt_person_id = nvl(ben_ext_person.g_chg_prmtr_06,'-1') then

3463: hr_utility.set_location(' Entering:'||l_proc, 5);
3464: end if;
3465:
3466: --link the entrolled dependent with change even dependent
3467: if p_dpnt_person_id = nvl(ben_ext_person.g_chg_prmtr_06,'-1') then
3468: if p_excld_flag = 'N' then
3469: raise g_include;
3470: else
3471: raise g_not_include;

Line 3542: if ben_ext_person.g_chg_enrt_rslt_id is null then

3538: --
3539: for i in 1..g_enrt_rltn_list.count
3540: loop
3541: if g_enrt_rltn_list(i) = 'EERCEP' then
3542: if ben_ext_person.g_chg_enrt_rslt_id is null then
3543: raise g_include;
3544: end if;
3545: if p_prtt_enrt_rslt_id = ben_ext_person.g_chg_enrt_rslt_id then
3546: if p_excld_flag = 'N' then

Line 3545: if p_prtt_enrt_rslt_id = ben_ext_person.g_chg_enrt_rslt_id then

3541: if g_enrt_rltn_list(i) = 'EERCEP' then
3542: if ben_ext_person.g_chg_enrt_rslt_id is null then
3543: raise g_include;
3544: end if;
3545: if p_prtt_enrt_rslt_id = ben_ext_person.g_chg_enrt_rslt_id then
3546: if p_excld_flag = 'N' then
3547: raise g_include;
3548: else
3549: raise g_not_include;

Line 3553: if ben_ext_person.g_cm_per_in_ler_id is null then

3549: raise g_not_include;
3550: end if;
3551: end if;
3552: elsif g_enrt_rltn_list(i) = 'EERCMP' then
3553: if ben_ext_person.g_cm_per_in_ler_id is null then
3554: raise g_include;
3555: end if;
3556: if p_per_in_ler_id = ben_ext_person.g_cm_per_in_ler_id then
3557: if p_excld_flag = 'N' then

Line 3556: if p_per_in_ler_id = ben_ext_person.g_cm_per_in_ler_id then

3552: elsif g_enrt_rltn_list(i) = 'EERCMP' then
3553: if ben_ext_person.g_cm_per_in_ler_id is null then
3554: raise g_include;
3555: end if;
3556: if p_per_in_ler_id = ben_ext_person.g_cm_per_in_ler_id then
3557: if p_excld_flag = 'N' then
3558: raise g_include;
3559: else
3560: raise g_not_include;

Line 3565: open c_cm_usg (ben_ext_person.g_per_cm_id, p_pl_id, p_pl_typ_id, p_pgm_id);

3561: end if;
3562: end if;
3563: -- Enrt Rslt Comp Object must match that the communication usage.
3564: elsif g_enrt_rltn_list(i) = 'EERCMU' then
3565: open c_cm_usg (ben_ext_person.g_per_cm_id, p_pl_id, p_pl_typ_id, p_pgm_id);
3566: fetch c_cm_usg into l_dummy;
3567: if c_cm_usg%found then
3568: if p_excld_flag = 'N' then
3569: close c_cm_usg;

Line 4308: if ben_ext_person.g_cm_per_in_ler_id is null then

4304: --
4305: for i in 1..g_elct_rltn_list.count
4306: loop
4307: if g_elct_rltn_list(i) = 'EECCMP' then
4308: if ben_ext_person.g_cm_per_in_ler_id is null then
4309: raise g_include;
4310: end if;
4311: if p_per_in_ler_id = ben_ext_person.g_cm_per_in_ler_id then
4312: if p_excld_flag = 'N' then

Line 4311: if p_per_in_ler_id = ben_ext_person.g_cm_per_in_ler_id then

4307: if g_elct_rltn_list(i) = 'EECCMP' then
4308: if ben_ext_person.g_cm_per_in_ler_id is null then
4309: raise g_include;
4310: end if;
4311: if p_per_in_ler_id = ben_ext_person.g_cm_per_in_ler_id then
4312: if p_excld_flag = 'N' then
4313: raise g_include;
4314: else
4315: raise g_not_include;

Line 5209: if ben_ext_person.g_cm_prtt_enrt_actn_id is null then

5205: --
5206: for i in 1..g_actn_item_rltn_list.count
5207: loop
5208: if g_actn_item_rltn_list(i) = 'EAICMP' then
5209: if ben_ext_person.g_cm_prtt_enrt_actn_id is null then
5210: raise g_include;
5211: end if;
5212: if p_prtt_enrt_actn_id = ben_ext_person.g_cm_prtt_enrt_actn_id then
5213: if p_excld_flag = 'N' then

Line 5212: if p_prtt_enrt_actn_id = ben_ext_person.g_cm_prtt_enrt_actn_id then

5208: if g_actn_item_rltn_list(i) = 'EAICMP' then
5209: if ben_ext_person.g_cm_prtt_enrt_actn_id is null then
5210: raise g_include;
5211: end if;
5212: if p_prtt_enrt_actn_id = ben_ext_person.g_cm_prtt_enrt_actn_id then
5213: if p_excld_flag = 'N' then
5214: raise g_include;
5215: else
5216: raise g_not_include;

Line 6058: and asg.assignment_id = ben_ext_person.g_assignment_id --1969853

6054: cursor c_asg is
6055: SELECT asg.assignment_id, asg.business_group_id
6056: FROM per_all_assignments_f asg
6057: WHERE asg.person_id = p_person_id
6058: and asg.assignment_id = ben_ext_person.g_assignment_id --1969853
6059: AND asg.primary_flag = 'Y'
6060: AND p_effective_date between asg.effective_start_date
6061: and asg.effective_end_date;
6062: --