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 PAY_PAYROLL_ACTIONS

Line 86: FROM pay_payroll_actions

82: INSTR(legislative_parameters,' ',
83: INSTR(legislative_parameters,p_token))
84: - (INSTR(legislative_parameters,p_token)+LENGTH(p_token))),
85: business_group_id
86: FROM pay_payroll_actions
87: WHERE payroll_action_id = p_pact_id;
88:
89: l_business_group_id VARCHAR2(20);
90: l_token_value VARCHAR2(50);

Line 186: pay_payroll_actions ppa,

182: select fnd_date.canonical_to_date(act_inf.action_information3)
183: from pay_assignment_actions paa_run,
184: pay_action_interlocks pai,
185: pay_assignment_actions paa,
186: pay_payroll_actions ppa,
187: pay_action_information act_inf
188: where ppa.payroll_action_id = paa.payroll_action_id
189: and ppa.report_type = 'IE_CESSATION'
190: and ppa.report_qualifier = 'IE'

Line 305: pay_payroll_actions ppa,

301: /* CURSOR get_last_source_id is
302: select source_id from
303: pay_action_information pai,
304: pay_assignment_actions paa,
305: pay_payroll_actions ppa,
306: pay_assignment_actions paa1
307: where paa.assignment_action_id = p_last_cess_action
308: and ppa.payroll_action_id=paa.payroll_action_id
309: and ppa.payroll_action_id=paa1.payroll_action_id

Line 331: pay_payroll_actions ppa,

327: /* CURSOR get_last_source_id_apr_09 is
328: select source_id , ppa.effective_date from
329: pay_action_information pai,
330: pay_assignment_actions paa,
331: pay_payroll_actions ppa,
332: pay_assignment_actions paa1
333: where paa.assignment_action_id = p_last_cess_action
334: and ppa.payroll_action_id=paa.payroll_action_id
335: and ppa.payroll_action_id=paa1.payroll_action_id

Line 345: pay_payroll_actions ppa

341: CURSOR get_last_source_id_apr_09 is
342: select source_id , ppa.effective_date from
343: pay_action_information pai,
344: pay_assignment_actions paa,
345: pay_payroll_actions ppa
346: where paa.assignment_action_id = p_last_cess_action
347: and ppa.payroll_action_id=paa.payroll_action_id
348: and paa.assignment_action_id = pai.action_context_id
349: and pai.action_information_category='IE CESS INFORMATION'

Line 356: pay_payroll_actions ppa

352:
353: CURSOR get_asg_action_eff_date(c_assignment_action_id pay_assignment_actions.assignment_action_id%type) is
354: select ppa.effective_date
355: from pay_assignment_actions paa,
356: pay_payroll_actions ppa
357: where paa.assignment_action_id=c_assignment_action_id
358: and ppa.payroll_action_id=paa.payroll_action_id;
359:
360:

Line 390: ,pay_payroll_actions ppa

386: CURSOR cur_assignment_action_apr_09(c_ppsn varchar2) is
387: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
388: paa.assignment_action_id),16))
389: FROM pay_assignment_actions paa
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

Line 1560: pay_payroll_actions ppa

1556: hr_utility.set_location('l_bg_id = ' || l_bg_id,20);
1557:
1558: sqlstr := 'SELECT DISTINCT person_id
1559: FROM per_people_f ppf,
1560: pay_payroll_actions ppa
1561: WHERE ppa.payroll_action_id = :payroll_action_id
1562: AND ppa.business_group_id +0= ppf.business_group_id
1563: ORDER BY ppf.person_id';
1564:

Line 1599: pay_payroll_actions appa,

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,
1602: pay_payroll_actions appa2
1603: WHERE /*appa.consolidation_set_id = p_consolidation_id*/

Line 1602: pay_payroll_actions appa2

1598: pay_assignment_actions act,
1599: pay_payroll_actions appa,
1600: pay_action_interlocks pai,
1601: pay_assignment_actions act1,
1602: pay_payroll_actions appa2
1603: WHERE /*appa.consolidation_set_id = p_consolidation_id*/
1604: act.tax_unit_id = p_paye_ref
1605: AND appa.effective_date BETWEEN g_archive_start_date AND g_archive_end_date
1606: AND as1.person_id BETWEEN stperson AND endperson

Line 1658: pay_payroll_actions appa4

1654: AND appa2.payroll_action_id = (SELECT /*+ USE_NL(ACT2 APPA4)*/
1655: max(appa4.payroll_action_id)
1656: FROM /*pay_pre_payments ppp, --Bug 4193738 --Bug 4468864*/
1657: pay_assignment_actions act2,
1658: pay_payroll_actions appa4
1659: WHERE /*ppp.assignment_action_id=act2.assignment_action_id
1660: AND*/ act2.assignment_id = act.assignment_id
1661: AND act2.action_status = 'C'
1662: AND appa4.payroll_action_id = act2.payroll_action_id

Line 1669: pay_payroll_actions appa3,

1665: -- bug 5597735, change the not exists clause.
1666: -- refer bug 5233518 for more details.
1667: AND NOT EXISTS (SELECT /*+ ORDERED use_nl(appa3)*/ null
1668: from pay_assignment_actions act3,
1669: pay_payroll_actions appa3,
1670: pay_action_interlocks pai, --bug 4208273
1671: pay_assignment_actions act2, --bug 4208273
1672: pay_payroll_actions appa4 --bug 4208273
1673: where pai.locked_action_id= act3.assignment_action_id

Line 1672: pay_payroll_actions appa4 --bug 4208273

1668: from pay_assignment_actions act3,
1669: pay_payroll_actions appa3,
1670: pay_action_interlocks pai, --bug 4208273
1671: pay_assignment_actions act2, --bug 4208273
1672: pay_payroll_actions appa4 --bug 4208273
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

Line 1921: FROM pay_payroll_actions

1917: IS
1918:
1919: CURSOR csr_archive_effective_date(pactid NUMBER) IS
1920: SELECT effective_date
1921: FROM pay_payroll_actions
1922: WHERE payroll_action_id = pactid;
1923:
1924: CURSOR csr_input_value_id(p_element_name CHAR,
1925: p_value_name CHAR) IS

Line 2026: pay_payroll_actions paa,

2022: paa.date_earned date_earned,
2023: ptp.time_period_id time_period_id
2024: FROM pay_action_interlocks pre,
2025: pay_action_interlocks pay,
2026: pay_payroll_actions paa,
2027: pay_payroll_actions ppaa,
2028: pay_assignment_actions assact,
2029: pay_assignment_actions passact,
2030: per_time_periods ptp -- Added to retrieve correct time_period_id 4906850

Line 2027: pay_payroll_actions ppaa,

2023: ptp.time_period_id time_period_id
2024: FROM pay_action_interlocks pre,
2025: pay_action_interlocks pay,
2026: pay_payroll_actions paa,
2027: pay_payroll_actions ppaa,
2028: pay_assignment_actions assact,
2029: pay_assignment_actions passact,
2030: per_time_periods ptp -- Added to retrieve correct time_period_id 4906850
2031: WHERE pre.locked_action_id = pay.locking_action_id

Line 2055: pay_payroll_actions ppa

2051: SELECT /*+ USE_NL(paa, ppa) */
2052: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2053: paa.assignment_action_id),16))
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

Line 2074: FROM pay_payroll_actions ppa_cess,

2070: p_person_id NUMBER,
2071: c_ppsn varchar2
2072: ) IS
2073: SELECT max(lpad(paa_src.action_sequence,15,'0')|| paa_src.assignment_action_id)
2074: FROM pay_payroll_actions ppa_cess,
2075: pay_assignment_actions cess_src,
2076: pay_action_information pai_cess,
2077: pay_assignment_actions paa_src
2078: WHERE ppa_cess.action_type = 'X'

Line 2099: FROM pay_payroll_actions ppa,

2095:
2096: CURSOR cur_get_last_cess(p_person_id NUMBER,p_termination_date DATE,p_pact NUMBER, c_assignment_id NUMBER,c_ppsn varchar2) IS
2097: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2098: paa.assignment_action_id),16))
2099: FROM pay_payroll_actions ppa,
2100: pay_assignment_actions paa,
2101: pay_action_information pai
2102: WHERE paa.assignment_action_id = pai.action_context_id
2103: AND pai.action_information_category = 'IE CESS INFORMATION'

Line 2152: pay_payroll_actions ppa

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,
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