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.PAY_IE_CESS_REPORT dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 394: from per_all_assignments_f paaf, per_assignment_extra_info paei

390: ,pay_payroll_actions ppa
391: -- ,pay_assignment_actions paa1
392: WHERE ((c_ppsn is null and paa.assignment_id=p_assignment_id) OR(c_ppsn is not null
393: and paa.assignment_id in (select paaf.assignment_id
394: from per_all_assignments_f paaf, per_assignment_extra_info paei
395: where paaf.person_id = p_person_id
396: and paaf.assignment_id=paei.assignment_id
397: and paei.information_type = 'IE_ASG_OVERRIDE'
398: and paei.aei_information1 = c_ppsn --'314678745T'

Line 470: from per_assignment_extra_info

466:
467: cursor csr_ppsn_override(p_asg_id number)
468: is
469: select aei_information1 PPSN_OVERRIDE
470: from per_assignment_extra_info
471: where assignment_id = p_asg_id
472: and aei_information_category = 'IE_ASG_OVERRIDE';
473:
474: l_ppsn_override per_assignment_extra_info.aei_information1%type:=null;

Line 474: l_ppsn_override per_assignment_extra_info.aei_information1%type:=null;

470: from per_assignment_extra_info
471: where assignment_id = p_asg_id
472: and aei_information_category = 'IE_ASG_OVERRIDE';
473:
474: l_ppsn_override per_assignment_extra_info.aei_information1%type:=null;
475:
476:
477: BEGIN
478: --

Line 1719: from per_assignment_extra_info

1715:
1716: cursor csr_ppsn_override(p_asg_id number)
1717: is
1718: select aei_information1 PPSN_OVERRIDE
1719: from per_assignment_extra_info
1720: where assignment_id = p_asg_id
1721: and aei_information_category = 'IE_ASG_OVERRIDE';
1722:
1723: l_ppsn_override per_assignment_extra_info.aei_information1%type;

Line 1723: l_ppsn_override per_assignment_extra_info.aei_information1%type;

1719: from per_assignment_extra_info
1720: where assignment_id = p_asg_id
1721: and aei_information_category = 'IE_ASG_OVERRIDE';
1722:
1723: l_ppsn_override per_assignment_extra_info.aei_information1%type;
1724:
1725: /*
1726: cursor csr_ppsn_min_asg(p_ppsn_override varchar2, p_person_id number)
1727: is

Line 1729: from per_assignment_extra_info paei

1725: /*
1726: cursor csr_ppsn_min_asg(p_ppsn_override varchar2, p_person_id number)
1727: is
1728: select MIN(paei.assignment_id) ovrride_asg
1729: from per_assignment_extra_info paei
1730: where paei.information_type = 'IE_ASG_OVERRIDE'
1731: and paei.aei_information1 = p_ppsn_override
1732: and exists
1733: (select 1 from per_all_assignments_f paaf

Line 1741: from per_assignment_extra_info paei,per_all_assignments_f paaf

1737: /* 8615992 */
1738: cursor csr_ppsn_min_asg(p_ppsn_override varchar2, p_person_id number,c_period_of_service_id number)
1739: is
1740: select MIN(paei.assignment_id) ovrride_asg
1741: from per_assignment_extra_info paei,per_all_assignments_f paaf
1742: where paei.information_type = 'IE_ASG_OVERRIDE'
1743: and paei.aei_information1 = p_ppsn_override
1744: and paaf.assignment_id = paei.assignment_id
1745: and paaf.person_id = p_person_id

Line 1750: l_ppsn_override_asg per_assignment_extra_info.assignment_id%type;

1746: and paaf.period_of_service_id=c_period_of_service_id
1747: GROUP BY paei.aei_information1;
1748:
1749:
1750: l_ppsn_override_asg per_assignment_extra_info.assignment_id%type;
1751: l_temp_person_id per_people_f.person_id%TYPE :=0;
1752:
1753:
1754: l_actid NUMBER;

Line 2138: from per_assignment_extra_info

2134:
2135: cursor csr_ppsn_override(p_asg_id number)
2136: is
2137: select aei_information1 PPSN_OVERRIDE
2138: from per_assignment_extra_info
2139: where assignment_id = p_asg_id
2140: and aei_information_category = 'IE_ASG_OVERRIDE';
2141:
2142: l_ppsn_override per_assignment_extra_info.aei_information1%type;

Line 2142: l_ppsn_override per_assignment_extra_info.aei_information1%type;

2138: from per_assignment_extra_info
2139: where assignment_id = p_asg_id
2140: and aei_information_category = 'IE_ASG_OVERRIDE';
2141:
2142: l_ppsn_override per_assignment_extra_info.aei_information1%type;
2143:
2144: CURSOR cur_child_pay_action_ppsn (p_person_id IN NUMBER,
2145: p_effective_date IN DATE,
2146: p_lat_act_seq IN NUMBER,

Line 2147: c_ppsn_override per_assignment_extra_info.aei_information1%type) is

2143:
2144: CURSOR cur_child_pay_action_ppsn (p_person_id IN NUMBER,
2145: p_effective_date IN DATE,
2146: p_lat_act_seq IN NUMBER,
2147: c_ppsn_override per_assignment_extra_info.aei_information1%type) is
2148: SELECT /*+ USE_NL(paa, ppa) */
2149: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2150: paa.assignment_action_id),16))
2151: FROM pay_assignment_actions paa,

Line 2155: from per_all_assignments_f paaf, per_assignment_extra_info paei

2151: FROM pay_assignment_actions paa,
2152: pay_payroll_actions ppa
2153: WHERE paa.payroll_action_id = ppa.payroll_action_id
2154: AND paa.assignment_id in (select paaf.assignment_id
2155: from per_all_assignments_f paaf, per_assignment_extra_info paei
2156: where paaf.person_id = p_person_id
2157: and paaf.assignment_id=paei.assignment_id
2158: and paei.information_type = 'IE_ASG_OVERRIDE'
2159: and paei.aei_information1 = c_ppsn_override --'314678745T'