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_ALL_ASSIGNMENTS_F

Line 144: from per_all_assignments_f paf,

140: ppos.actual_termination_date
141: from per_periods_of_service ppos
142: where ppos.person_id = p_person_id
143: and ppos.period_of_service_id = (select max(paf.period_of_service_id)
144: from per_all_assignments_f paf,
145: pay_assignment_actions paa,
146: pay_action_interlocks pai
147: where pai.locking_action_id = p_action_context_id
148: and pai.locked_action_id = paa.assignment_action_id

Line 155: FROM per_all_assignments_f paaf,

151: );
152:
153: CURSOR cur_max_end_date IS
154: SELECT max(paaf.effective_end_date)
155: FROM per_all_assignments_f paaf,
156: pay_all_payrolls_f papf,
157: hr_soft_coding_keyflex scl
158: WHERE paaf.person_id = p_person_id
159: AND paaf.payroll_id = papf.payroll_id

Line 171: FROM per_all_assignments_f paaf

167: AND paaf.effective_end_date between g_archive_start_date and g_archive_end_date;
168:
169: CURSOR cur_get_asg_end_date IS
170: SELECT max(effective_end_date)
171: FROM per_all_assignments_f paaf
172: WHERE paaf.assignment_id = p_assignment_id
173: AND paaf.assignment_status_type_id in
174: (SELECT ast.assignment_status_type_id
175: FROM per_assignment_status_types ast

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 1597: per_all_assignments_f as1,

1593: act1.assignment_action_id prepaid_action_id,
1594: as1.assignment_number works_number,
1595: as1.period_of_service_id period_of_service_id
1596: FROM --per_periods_of_service ppos,
1597: per_all_assignments_f as1,
1598: pay_assignment_actions act,
1599: pay_payroll_actions appa,
1600: pay_action_interlocks pai,
1601: pay_assignment_actions act1,

Line 1610: from per_all_assignments_f paf1

1606: AND as1.person_id BETWEEN stperson AND endperson
1607:
1608: AND as1.effective_end_date between g_archive_start_date AND g_archive_end_date
1609: AND (as1.effective_end_date = (select max(effective_end_date)
1610: from per_all_assignments_f paf1
1611: where paf1.assignment_id = as1.assignment_id
1612:
1613: and paf1.assignment_status_type_id in
1614: (SELECT ast.assignment_status_type_id

Line 1632: from per_all_assignments_f paf1

1628: and a.effective_start_date <= g_archive_end_date
1629:
1630:
1631: and a.effective_end_date = (select max(effective_end_date)
1632: from per_all_assignments_f paf1
1633: where paf1.assignment_id = a.assignment_id
1634: and paf1.assignment_status_type_id in
1635: (SELECT ast.assignment_status_type_id
1636: FROM per_assignment_status_types ast

Line 1677: from per_all_assignments_f paaf

1673: where pai.locked_action_id= act3.assignment_action_id
1674: and pai.locking_action_id=act2.assignment_action_id
1675: and act3.action_sequence >= act1.action_sequence --bug 4193738
1676: and act3.assignment_id in (select distinct paaf.assignment_id
1677: from per_all_assignments_f paaf
1678: where paaf.person_id = as1.person_id
1679: )
1680: and act3.tax_unit_id = act1.tax_unit_id
1681: and act3.action_status = 'C'

Line 1691: FROM per_all_assignments_f paf,

1687: and appa3.report_type = 'IE_CESSATION')
1688: /* check person does not hold employment with the employer between start of year and archive end date */
1689: AND NOT EXISTS (
1690: SELECT MIN(paf.effective_start_date),MAX(paf.effective_end_date)
1691: FROM per_all_assignments_f paf,
1692: pay_all_payrolls_f papf,
1693: hr_soft_coding_keyflex scl
1694: WHERE paf.person_id = as1.person_id
1695: AND paf.payroll_id = papf.payroll_id

Line 1733: (select 1 from per_all_assignments_f paaf

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
1734: where paaf.assignment_id = paei.assignment_id
1735: and paaf.person_id = p_person_id)
1736: GROUP BY paei.aei_information1; */
1737: /* 8615992 */

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 2058: from per_all_assignments_f

2054: FROM pay_assignment_actions paa,
2055: pay_payroll_actions ppa
2056: WHERE paa.payroll_action_id = ppa.payroll_action_id
2057: AND paa.assignment_id in (select assignment_id
2058: from per_all_assignments_f
2059: where person_id = p_person_id
2060: )
2061: AND paa.tax_unit_id = g_paye_ref
2062: AND (paa.source_action_id is not null or ppa.action_type in ('I','V','B'))

Line 2128: FROM per_all_assignments_f

2124: -- cursor to retrieve payroll id
2125: CURSOR cur_assgn_payroll(p_assignment_id NUMBER,
2126: p_date_earned DATE) IS
2127: SELECT payroll_id,person_id,period_of_service_id
2128: FROM per_all_assignments_f
2129: WHERE assignment_id = p_assignment_id
2130: AND p_date_earned
2131: BETWEEN effective_start_date AND effective_end_date;
2132:

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'

Line 2430: l_assignment_id per_all_assignments_f.assignment_id%type;

2426:
2427: l_payroll_action_id NUMBER;
2428: l_asg_action_id NUMBER;
2429:
2430: l_assignment_id per_all_assignments_f.assignment_id%type;
2431: CURSOR cur_assignment_id (c_assignment_action_id pay_assignment_actions.assignment_action_id%type) is
2432: select assignment_id
2433: from pay_assignment_actions
2434: where assignment_action_id=c_assignment_action_id;

Line 2436: l_assignment_id per_all_assignments_f.assignment_id%type;

2432: select assignment_id
2433: from pay_assignment_actions
2434: where assignment_action_id=c_assignment_action_id;
2435:
2436: l_assignment_id per_all_assignments_f.assignment_id%type;
2437:
2438:
2439: CURSOR cur_cess_emp_details (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS
2440: select PAI_IEcess.ACTION_INFORMATION20 last_name,