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_IN_24QC_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

Line 381: FROM pay_payroll_actions

377: INSTR(legislative_parameters,' ',
378: INSTR(legislative_parameters,p_token))
379: - (INSTR(legislative_parameters,p_token)+LENGTH(p_token)))
380: ,business_group_id
381: FROM pay_payroll_actions
382: WHERE payroll_action_id = p_pact_id;
383:
384: l_token_value VARCHAR2(150);
385: l_bg_id NUMBER;

Line 442: ,pay_payroll_actions ppa

438: CURSOR csr_arch_ref_no(p_payroll_action_id NUMBER)
439: IS
440: SELECT 1
441: FROM pay_action_information pai
442: ,pay_payroll_actions ppa
443: WHERE pai.action_information_category = 'IN_24QC_ORG'
444: AND pai.action_context_type = 'PA'
445: AND pai.action_information1 = g_gre_id
446: AND pai.action_information3 = g_year||g_quarter

Line 1765: ,pay_payroll_actions ppa

1761: (
1762: SELECT
1763: paa.assignment_action_id run_asg_action_id
1764: FROM pay_assignment_actions paa
1765: ,pay_payroll_actions ppa
1766: ,per_assignments_f paf
1767: WHERE paf.assignment_id = paa.assignment_id
1768: AND paa.assignment_id = pai.assignment_id
1769: AND paa.tax_unit_id = pai.action_information3

Line 1780: pay_payroll_actions ppa1

1776: AND (1 = DECODE(ppa.action_type,'I',1,0)
1777: OR EXISTS (SELECT ''
1778: FROM pay_action_interlocks intk,
1779: pay_assignment_actions paa1,
1780: pay_payroll_actions ppa1
1781: WHERE intk.locked_action_id = paa.assignment_Action_id
1782: AND intk.locking_action_id = paa1.assignment_action_id
1783: AND paa1.payroll_action_id =ppa1.payroll_action_id
1784: AND ppa1.action_type in('P','U')

Line 1829: ,pay_payroll_actions ppa

1825: FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) source_id
1826: ,paf.assignment_id assignment_id
1827: ,NULL last_action_context_id
1828: FROM pay_assignment_actions paa
1829: ,pay_payroll_actions ppa
1830: ,per_assignments_f paf
1831: WHERE paf.person_id BETWEEN p_start_person AND p_end_person
1832: AND paf.assignment_id = paa.assignment_id
1833: AND paa.tax_unit_id = g_gre_id

Line 1844: pay_payroll_actions ppa1

1840: AND (1 = DECODE(ppa.action_type,'I',1,0)
1841: OR EXISTS (SELECT ''
1842: FROM pay_action_interlocks intk,
1843: pay_assignment_actions paa1,
1844: pay_payroll_actions ppa1
1845: WHERE intk.locked_action_id = paa.assignment_Action_id
1846: AND intk.locking_action_id = paa1.assignment_action_id
1847: AND paa1.payroll_action_id =ppa1.payroll_action_id
1848: AND ppa1.action_type in('P','U')

Line 1970: ,pay_payroll_actions ppa

1966: (
1967: SELECT
1968: paa.assignment_action_id run_asg_action_id
1969: FROM pay_assignment_actions paa
1970: ,pay_payroll_actions ppa
1971: ,per_assignments_f paf
1972: WHERE paf.person_id BETWEEN p_start_person AND p_end_person
1973: AND paf.assignment_id = paa.assignment_id
1974: AND paa.assignment_id = pai.assignment_id

Line 1986: pay_payroll_actions ppa1

1982: AND (1 = DECODE(ppa.action_type,'I',1,0)
1983: OR EXISTS (SELECT ''
1984: FROM pay_action_interlocks intk,
1985: pay_assignment_actions paa1,
1986: pay_payroll_actions ppa1
1987: WHERE intk.locked_action_id = paa.assignment_Action_id
1988: AND intk.locking_action_id = paa1.assignment_action_id
1989: AND paa1.payroll_action_id =ppa1.payroll_action_id
1990: AND ppa1.action_type in('P','U')

Line 2150: ,pay_payroll_actions ppa

2146: (
2147: SELECT
2148: paa.assignment_action_id run_asg_action_id
2149: FROM pay_assignment_actions paa
2150: ,pay_payroll_actions ppa
2151: ,per_assignments_f paf
2152: WHERE paf.person_id BETWEEN p_start_person AND p_end_person
2153: AND paf.assignment_id = paa.assignment_id
2154: AND paa.assignment_id = pai.assignment_id

Line 2166: pay_payroll_actions ppa1

2162: AND (1 = DECODE(ppa.action_type,'I',1,0)
2163: OR EXISTS (SELECT ''
2164: FROM pay_action_interlocks intk,
2165: pay_assignment_actions paa1,
2166: pay_payroll_actions ppa1
2167: WHERE intk.locked_action_id = paa.assignment_Action_id
2168: AND intk.locking_action_id = paa1.assignment_action_id
2169: AND paa1.payroll_action_id =ppa1.payroll_action_id
2170: AND ppa1.action_type in('P','U')

Line 2427: ,pay_payroll_actions ppa

2423: FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) source_id
2424: ,paf.assignment_id assignment_id
2425: ,NULL last_action_context_id
2426: FROM pay_assignment_actions paa
2427: ,pay_payroll_actions ppa
2428: ,per_assignments_f paf
2429: WHERE paf.person_id BETWEEN p_start_person AND p_end_person
2430: AND paf.assignment_id = paa.assignment_id
2431: AND paa.tax_unit_id = g_gre_id

Line 2442: pay_payroll_actions ppa1

2438: AND (1 = DECODE(ppa.action_type,'I',1,0)
2439: OR EXISTS (SELECT ''
2440: FROM pay_action_interlocks intk,
2441: pay_assignment_actions paa1,
2442: pay_payroll_actions ppa1
2443: WHERE intk.locked_action_id = paa.assignment_Action_id
2444: AND intk.locking_action_id = paa1.assignment_action_id
2445: AND paa1.payroll_action_id =ppa1.payroll_action_id
2446: AND ppa1.action_type in('P','U')

Line 4394: ,pay_payroll_actions ppa

4390: )
4391: IS
4392: SELECT FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) run_asg_action_id
4393: FROM pay_assignment_actions paa
4394: ,pay_payroll_actions ppa
4395: ,per_assignments_f paf
4396: WHERE paf.assignment_id = paa.assignment_id
4397: AND paf.assignment_id = p_assignment_id
4398: AND paa.tax_unit_id = p_tax_unit_id

Line 4409: pay_payroll_actions ppa1

4405: AND (1 = DECODE(ppa.action_type,'I',1,0)
4406: OR EXISTS (SELECT ''
4407: FROM pay_action_interlocks intk,
4408: pay_assignment_actions paa1,
4409: pay_payroll_actions ppa1
4410: WHERE intk.locked_action_id = paa.assignment_Action_id
4411: AND intk.locking_action_id = paa1.assignment_action_id
4412: AND paa1.payroll_action_id =ppa1.payroll_action_id
4413: AND paa1.assignment_id = p_assignment_id

Line 5022: ,pay_payroll_actions ppa

5018: SELECT
5019: FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) source_id
5020: ,paf.assignment_id assignment_id
5021: FROM pay_assignment_actions paa
5022: ,pay_payroll_actions ppa
5023: ,per_assignments_f paf
5024: WHERE paf.assignment_id = paa.assignment_id
5025: AND paf.assignment_id =p_assignment_id
5026: AND paa.tax_unit_id = g_gre_id

Line 5037: pay_payroll_actions ppa1

5033: AND (1 = DECODE(ppa.action_type,'I',1,0)
5034: OR EXISTS (SELECT ''
5035: FROM pay_action_interlocks intk,
5036: pay_assignment_actions paa1,
5037: pay_payroll_actions ppa1
5038: WHERE intk.locked_action_id = paa.assignment_Action_id
5039: AND intk.locking_action_id = paa1.assignment_action_id
5040: AND paa1.payroll_action_id =ppa1.payroll_action_id
5041: AND ppa1.action_type in('P','U')

Line 5054: ,pay_payroll_actions ppa

5050: SELECT
5051: FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) source_id
5052: ,paf.assignment_id assignment_id
5053: FROM pay_assignment_actions paa
5054: ,pay_payroll_actions ppa
5055: ,per_assignments_f paf
5056: WHERE paf.assignment_id = paa.assignment_id
5057: AND paf.assignment_id =p_assignment_id
5058: AND paa.tax_unit_id = g_gre_id

Line 5070: pay_payroll_actions ppa1

5066: AND (1 = DECODE(ppa.action_type,'I',1,0)
5067: OR EXISTS (SELECT ''
5068: FROM pay_action_interlocks intk,
5069: pay_assignment_actions paa1,
5070: pay_payroll_actions ppa1
5071: WHERE intk.locked_action_id = paa.assignment_Action_id
5072: AND intk.locking_action_id = paa1.assignment_action_id
5073: AND paa1.payroll_action_id =ppa1.payroll_action_id
5074: AND ppa1.action_type in('P','U')