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 1872: ,pay_payroll_actions ppa

1868: (
1869: SELECT
1870: paa.assignment_action_id run_asg_action_id
1871: FROM pay_assignment_actions paa
1872: ,pay_payroll_actions ppa
1873: ,per_assignments_f paf
1874: WHERE paf.assignment_id = paa.assignment_id
1875: AND paa.assignment_id = pai.assignment_id
1876: AND paa.tax_unit_id = pai.action_information3

Line 1887: pay_payroll_actions ppa1

1883: AND (1 = DECODE(ppa.action_type,'I',1,0)
1884: OR EXISTS (SELECT ''
1885: FROM pay_action_interlocks intk,
1886: pay_assignment_actions paa1,
1887: pay_payroll_actions ppa1
1888: WHERE intk.locked_action_id = paa.assignment_Action_id
1889: AND intk.locking_action_id = paa1.assignment_action_id
1890: AND paa1.payroll_action_id =ppa1.payroll_action_id
1891: AND ppa1.action_type in('P','U')

Line 1936: ,pay_payroll_actions ppa

1932: FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) source_id
1933: ,paf.assignment_id assignment_id
1934: ,NULL last_action_context_id
1935: FROM pay_assignment_actions paa
1936: ,pay_payroll_actions ppa
1937: ,per_assignments_f paf
1938: WHERE paf.person_id BETWEEN p_start_person AND p_end_person
1939: AND paf.assignment_id = paa.assignment_id
1940: AND paa.tax_unit_id = g_gre_id

Line 1951: pay_payroll_actions ppa1

1947: AND (1 = DECODE(ppa.action_type,'I',1,0)
1948: OR EXISTS (SELECT ''
1949: FROM pay_action_interlocks intk,
1950: pay_assignment_actions paa1,
1951: pay_payroll_actions ppa1
1952: WHERE intk.locked_action_id = paa.assignment_Action_id
1953: AND intk.locking_action_id = paa1.assignment_action_id
1954: AND paa1.payroll_action_id =ppa1.payroll_action_id
1955: AND ppa1.action_type in('P','U')

Line 2077: ,pay_payroll_actions ppa

2073: (
2074: SELECT
2075: paa.assignment_action_id run_asg_action_id
2076: FROM pay_assignment_actions paa
2077: ,pay_payroll_actions ppa
2078: ,per_assignments_f paf
2079: WHERE paf.person_id BETWEEN p_start_person AND p_end_person
2080: AND paf.assignment_id = paa.assignment_id
2081: AND paa.assignment_id = pai.assignment_id

Line 2093: pay_payroll_actions ppa1

2089: AND (1 = DECODE(ppa.action_type,'I',1,0)
2090: OR EXISTS (SELECT ''
2091: FROM pay_action_interlocks intk,
2092: pay_assignment_actions paa1,
2093: pay_payroll_actions ppa1
2094: WHERE intk.locked_action_id = paa.assignment_Action_id
2095: AND intk.locking_action_id = paa1.assignment_action_id
2096: AND paa1.payroll_action_id =ppa1.payroll_action_id
2097: AND ppa1.action_type in('P','U')

Line 2257: ,pay_payroll_actions ppa

2253: (
2254: SELECT
2255: paa.assignment_action_id run_asg_action_id
2256: FROM pay_assignment_actions paa
2257: ,pay_payroll_actions ppa
2258: ,per_assignments_f paf
2259: WHERE paf.person_id BETWEEN p_start_person AND p_end_person
2260: AND paf.assignment_id = paa.assignment_id
2261: AND paa.assignment_id = pai.assignment_id

Line 2273: pay_payroll_actions ppa1

2269: AND (1 = DECODE(ppa.action_type,'I',1,0)
2270: OR EXISTS (SELECT ''
2271: FROM pay_action_interlocks intk,
2272: pay_assignment_actions paa1,
2273: pay_payroll_actions ppa1
2274: WHERE intk.locked_action_id = paa.assignment_Action_id
2275: AND intk.locking_action_id = paa1.assignment_action_id
2276: AND paa1.payroll_action_id =ppa1.payroll_action_id
2277: AND ppa1.action_type in('P','U')

Line 2534: ,pay_payroll_actions ppa

2530: FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) source_id
2531: ,paf.assignment_id assignment_id
2532: ,NULL last_action_context_id
2533: FROM pay_assignment_actions paa
2534: ,pay_payroll_actions ppa
2535: ,per_assignments_f paf
2536: WHERE paf.person_id BETWEEN p_start_person AND p_end_person
2537: AND paf.assignment_id = paa.assignment_id
2538: AND paa.tax_unit_id = g_gre_id

Line 2549: pay_payroll_actions ppa1

2545: AND (1 = DECODE(ppa.action_type,'I',1,0)
2546: OR EXISTS (SELECT ''
2547: FROM pay_action_interlocks intk,
2548: pay_assignment_actions paa1,
2549: pay_payroll_actions ppa1
2550: WHERE intk.locked_action_id = paa.assignment_Action_id
2551: AND intk.locking_action_id = paa1.assignment_action_id
2552: AND paa1.payroll_action_id =ppa1.payroll_action_id
2553: AND ppa1.action_type in('P','U')

Line 4718: ,pay_payroll_actions ppa

4714: )
4715: IS
4716: SELECT FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) run_asg_action_id
4717: FROM pay_assignment_actions paa
4718: ,pay_payroll_actions ppa
4719: ,per_assignments_f paf
4720: WHERE paf.assignment_id = paa.assignment_id
4721: AND paf.assignment_id = p_assignment_id
4722: AND paa.tax_unit_id = p_tax_unit_id

Line 4733: pay_payroll_actions ppa1

4729: AND (1 = DECODE(ppa.action_type,'I',1,0)
4730: OR EXISTS (SELECT ''
4731: FROM pay_action_interlocks intk,
4732: pay_assignment_actions paa1,
4733: pay_payroll_actions ppa1
4734: WHERE intk.locked_action_id = paa.assignment_Action_id
4735: AND intk.locking_action_id = paa1.assignment_action_id
4736: AND paa1.payroll_action_id =ppa1.payroll_action_id
4737: AND paa1.assignment_id = p_assignment_id

Line 5346: ,pay_payroll_actions ppa

5342: SELECT
5343: FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) source_id
5344: ,paf.assignment_id assignment_id
5345: FROM pay_assignment_actions paa
5346: ,pay_payroll_actions ppa
5347: ,per_assignments_f paf
5348: WHERE paf.assignment_id = paa.assignment_id
5349: AND paf.assignment_id =p_assignment_id
5350: AND paa.tax_unit_id = g_gre_id

Line 5361: pay_payroll_actions ppa1

5357: AND (1 = DECODE(ppa.action_type,'I',1,0)
5358: OR EXISTS (SELECT ''
5359: FROM pay_action_interlocks intk,
5360: pay_assignment_actions paa1,
5361: pay_payroll_actions ppa1
5362: WHERE intk.locked_action_id = paa.assignment_Action_id
5363: AND intk.locking_action_id = paa1.assignment_action_id
5364: AND paa1.payroll_action_id =ppa1.payroll_action_id
5365: AND ppa1.action_type in('P','U')

Line 5378: ,pay_payroll_actions ppa

5374: SELECT
5375: FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) source_id
5376: ,paf.assignment_id assignment_id
5377: FROM pay_assignment_actions paa
5378: ,pay_payroll_actions ppa
5379: ,per_assignments_f paf
5380: WHERE paf.assignment_id = paa.assignment_id
5381: AND paf.assignment_id =p_assignment_id
5382: AND paa.tax_unit_id = g_gre_id

Line 5394: pay_payroll_actions ppa1

5390: AND (1 = DECODE(ppa.action_type,'I',1,0)
5391: OR EXISTS (SELECT ''
5392: FROM pay_action_interlocks intk,
5393: pay_assignment_actions paa1,
5394: pay_payroll_actions ppa1
5395: WHERE intk.locked_action_id = paa.assignment_Action_id
5396: AND intk.locking_action_id = paa1.assignment_action_id
5397: AND paa1.payroll_action_id =ppa1.payroll_action_id
5398: AND ppa1.action_type in('P','U')