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_TRGL_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 253: pay_assignment_actions pa1, -- Cost asg actions.

249: ppa1.payroll_action_id,
250: pp.payroll_id,
251: pp.gl_set_of_books_id
252: FROM pay_payroll_actions ppa1, -- Cost pay actions
253: pay_assignment_actions pa1, -- Cost asg actions.
254: pay_action_interlocks pi3, -- Cost - Run
255: pay_action_interlocks pi1, -- Cost - Trans GL
256: pay_all_payrolls_f pp,
257: pay_action_classifications pac,

Line 259: pay_assignment_actions pa2, -- Payroll run asg actions.

255: pay_action_interlocks pi1, -- Cost - Trans GL
256: pay_all_payrolls_f pp,
257: pay_action_classifications pac,
258: pay_payroll_actions ppa2, -- Payroll run actions.
259: pay_assignment_actions pa2, -- Payroll run asg actions.
260: pay_action_interlocks pi2, -- Run - Trans GL
261: pay_assignment_actions pa, -- Trans GL asg actions
262: pay_payroll_actions ppa -- Trans GL pay actions
263: WHERE ppa.payroll_action_id = i_action_id

Line 261: pay_assignment_actions pa, -- Trans GL asg actions

257: pay_action_classifications pac,
258: pay_payroll_actions ppa2, -- Payroll run actions.
259: pay_assignment_actions pa2, -- Payroll run asg actions.
260: pay_action_interlocks pi2, -- Run - Trans GL
261: pay_assignment_actions pa, -- Trans GL asg actions
262: pay_payroll_actions ppa -- Trans GL pay actions
263: WHERE ppa.payroll_action_id = i_action_id
264: AND pa.payroll_action_id = ppa.payroll_action_id
265: AND pa.action_status <> 'C'

Line 541: pay_assignment_actions pa, -- TGL assignment action

537: SUM(DECODE(cst.debit_or_credit,''C'',cst.costed_value,0))
538: FROM pay_payroll_actions ppa, -- Run payroll action
539: pay_payroll_actions ppa1, -- Cost payroll action
540: per_all_assignments_f per,
541: pay_assignment_actions pa, -- TGL assignment action
542: pay_action_interlocks pi, -- interlock to costing
543: pay_assignment_actions pa1, -- Cost assignment action
544: pay_action_interlocks pi2, -- interlock to run
545: pay_assignment_actions pa3, -- run master assignment action

Line 543: pay_assignment_actions pa1, -- Cost assignment action

539: pay_payroll_actions ppa1, -- Cost payroll action
540: per_all_assignments_f per,
541: pay_assignment_actions pa, -- TGL assignment action
542: pay_action_interlocks pi, -- interlock to costing
543: pay_assignment_actions pa1, -- Cost assignment action
544: pay_action_interlocks pi2, -- interlock to run
545: pay_assignment_actions pa3, -- run master assignment action
546: pay_assignment_actions pa2, -- run assignment action
547: pay_costs cst,

Line 545: pay_assignment_actions pa3, -- run master assignment action

541: pay_assignment_actions pa, -- TGL assignment action
542: pay_action_interlocks pi, -- interlock to costing
543: pay_assignment_actions pa1, -- Cost assignment action
544: pay_action_interlocks pi2, -- interlock to run
545: pay_assignment_actions pa3, -- run master assignment action
546: pay_assignment_actions pa2, -- run assignment action
547: pay_costs cst,
548: pay_cost_allocation_keyflex caf,
549: pay_run_results rr,

Line 546: pay_assignment_actions pa2, -- run assignment action

542: pay_action_interlocks pi, -- interlock to costing
543: pay_assignment_actions pa1, -- Cost assignment action
544: pay_action_interlocks pi2, -- interlock to run
545: pay_assignment_actions pa3, -- run master assignment action
546: pay_assignment_actions pa2, -- run assignment action
547: pay_costs cst,
548: pay_cost_allocation_keyflex caf,
549: pay_run_results rr,
550: pay_input_values_f IV,

Line 745: pay_assignment_actions pa, -- TGL assignment action

741: SUM(DECODE(cst.debit_or_credit,''C'',cst.costed_value,0))
742: FROM pay_payroll_actions ppa, -- Run payroll action
743: pay_payroll_actions ppa1, -- Cost payroll action
744: per_all_assignments_f per,
745: pay_assignment_actions pa, -- TGL assignment action
746: pay_action_interlocks pi, -- interlock to costing
747: pay_assignment_actions pa1, -- Cost assignment action
748: pay_action_interlocks pi2, -- interlock to run
749: pay_assignment_actions pa3, -- run master assignment action

Line 747: pay_assignment_actions pa1, -- Cost assignment action

743: pay_payroll_actions ppa1, -- Cost payroll action
744: per_all_assignments_f per,
745: pay_assignment_actions pa, -- TGL assignment action
746: pay_action_interlocks pi, -- interlock to costing
747: pay_assignment_actions pa1, -- Cost assignment action
748: pay_action_interlocks pi2, -- interlock to run
749: pay_assignment_actions pa3, -- run master assignment action
750: pay_assignment_actions pa2, -- run assignment action
751: pay_costs cst,

Line 749: pay_assignment_actions pa3, -- run master assignment action

745: pay_assignment_actions pa, -- TGL assignment action
746: pay_action_interlocks pi, -- interlock to costing
747: pay_assignment_actions pa1, -- Cost assignment action
748: pay_action_interlocks pi2, -- interlock to run
749: pay_assignment_actions pa3, -- run master assignment action
750: pay_assignment_actions pa2, -- run assignment action
751: pay_costs cst,
752: pay_cost_allocation_keyflex caf,
753: pay_run_results rr,

Line 750: pay_assignment_actions pa2, -- run assignment action

746: pay_action_interlocks pi, -- interlock to costing
747: pay_assignment_actions pa1, -- Cost assignment action
748: pay_action_interlocks pi2, -- interlock to run
749: pay_assignment_actions pa3, -- run master assignment action
750: pay_assignment_actions pa2, -- run assignment action
751: pay_costs cst,
752: pay_cost_allocation_keyflex caf,
753: pay_run_results rr,
754: pay_input_values_f IV,

Line 940: UPDATE pay_assignment_actions pa

936: hr_utility.set_location('pytrgl.trans_pay_costs',90);
937: --
938: -- Update the assignment actions. Mark as processed.
939: --
940: UPDATE pay_assignment_actions pa
941: SET pa.action_status = 'C'
942: WHERE pa.action_status <> 'C'
943: AND pa.payroll_action_id = i_payroll_action_id
944: AND EXISTS

Line 951: pay_assignment_actions pa2, -- Payroll run actions.

947: NULL
948: FROM
949: pay_payroll_actions ppa,
950: pay_action_interlocks pi2, -- Run - Trans GL
951: pay_assignment_actions pa2, -- Payroll run actions.
952: pay_payroll_actions ppa2,
953: per_all_assignments_f per
954: WHERE pi2.locking_action_id = pa.assignment_action_id
955: AND pa.assignment_id = per.assignment_id

Line 1004: pay_assignment_actions pa, -- Trans GL asg actions

1000: pp.payroll_id,
1001: pp.gl_set_of_books_id,
1002: ppa1.payroll_id
1003: FROM pay_payroll_actions ppa, -- Trans GL pay actions
1004: pay_assignment_actions pa, -- Trans GL asg actions
1005: pay_action_interlocks pi2, -- Run - Trans GL
1006: pay_assignment_actions pa2, -- Payroll run asg actions.
1007: pay_payroll_actions ppa2, -- Payroll run actions.
1008: pay_action_classifications pac,

Line 1006: pay_assignment_actions pa2, -- Payroll run asg actions.

1002: ppa1.payroll_id
1003: FROM pay_payroll_actions ppa, -- Trans GL pay actions
1004: pay_assignment_actions pa, -- Trans GL asg actions
1005: pay_action_interlocks pi2, -- Run - Trans GL
1006: pay_assignment_actions pa2, -- Payroll run asg actions.
1007: pay_payroll_actions ppa2, -- Payroll run actions.
1008: pay_action_classifications pac,
1009: pay_all_payrolls_f pp,
1010: pay_action_interlocks pi1, -- Cost - Trans GL

Line 1011: pay_assignment_actions pa1, -- Cost asg actions.

1007: pay_payroll_actions ppa2, -- Payroll run actions.
1008: pay_action_classifications pac,
1009: pay_all_payrolls_f pp,
1010: pay_action_interlocks pi1, -- Cost - Trans GL
1011: pay_assignment_actions pa1, -- Cost asg actions.
1012: pay_action_interlocks pi3, -- Cost - Run
1013: pay_payroll_actions ppa1 -- Cost pay actions
1014: WHERE ppa.payroll_action_id = i_action_id
1015: AND pa.payroll_action_id = ppa.payroll_action_id

Line 1043: pay_assignment_actions pa, -- Trans GL asg actions

1039: pp.payroll_id,
1040: pp.gl_set_of_books_id,
1041: ppa1.payroll_id
1042: FROM pay_payroll_actions ppa, -- Trans GL pay actions
1043: pay_assignment_actions pa, -- Trans GL asg actions
1044: pay_action_interlocks pi1, -- Cost - Trans GL
1045: pay_assignment_actions pa1, -- Cost asg actions
1046: pay_payroll_actions ppa1, -- Cost pay actions
1047: per_all_assignments_f pera,

Line 1045: pay_assignment_actions pa1, -- Cost asg actions

1041: ppa1.payroll_id
1042: FROM pay_payroll_actions ppa, -- Trans GL pay actions
1043: pay_assignment_actions pa, -- Trans GL asg actions
1044: pay_action_interlocks pi1, -- Cost - Trans GL
1045: pay_assignment_actions pa1, -- Cost asg actions
1046: pay_payroll_actions ppa1, -- Cost pay actions
1047: per_all_assignments_f pera,
1048: pay_all_payrolls_f pp
1049: WHERE ppa.payroll_action_id = i_action_id

Line 1381: FROM pay_assignment_actions pa,

1377: :l_currency_type,
1378: :c_conversion_date,
1379: SUM(pgl.entered_dr),
1380: SUM(pgl.entered_cr)
1381: FROM pay_assignment_actions pa,
1382: '|| l_asg_tab ||'
1383: pay_action_interlocks int,
1384: pay_assignment_actions pa2,
1385: pay_gl_interface pgl,

Line 1384: pay_assignment_actions pa2,

1380: SUM(pgl.entered_cr)
1381: FROM pay_assignment_actions pa,
1382: '|| l_asg_tab ||'
1383: pay_action_interlocks int,
1384: pay_assignment_actions pa2,
1385: pay_gl_interface pgl,
1386: pay_cost_allocation_keyflex caf
1387: WHERE pgl.run_payroll_action_id = :c_run_action_id
1388: '|| l_asg_join ||'

Line 1450: FROM pay_assignment_actions pa,

1446: :l_currency_type,
1447: :c_conversion_date,
1448: SUM(pgl.entered_dr),
1449: SUM(pgl.entered_cr)
1450: FROM pay_assignment_actions pa,
1451: '|| l_asg_tab ||'
1452: pay_action_interlocks int,
1453: pay_assignment_actions pa2,
1454: pay_gl_interface pgl,

Line 1453: pay_assignment_actions pa2,

1449: SUM(pgl.entered_cr)
1450: FROM pay_assignment_actions pa,
1451: '|| l_asg_tab ||'
1452: pay_action_interlocks int,
1453: pay_assignment_actions pa2,
1454: pay_gl_interface pgl,
1455: pay_cost_allocation_keyflex caf
1456: WHERE pgl.run_payroll_action_id = :c_run_action_id
1457: '|| l_asg_join ||'

Line 1544: r_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

1540: c_payroll_action_id NUMBER;
1541: r_payroll_action_id NUMBER;
1542: r_action_type pay_payroll_actions.action_type%TYPE;
1543: r_assignment_id NUMBER;
1544: r_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
1545: c_action_type pay_payroll_actions.action_type%TYPE;
1546: l_date_used VARCHAR2(80);
1547: l_accounting_date DATE;
1548: BEGIN

Line 1574: FROM pay_assignment_actions pa, -- TGL assignment action

1570: r_assignment_id,
1571: c_assignment_action_id,
1572: c_payroll_action_id,
1573: c_action_type
1574: FROM pay_assignment_actions pa, -- TGL assignment action
1575: pay_action_interlocks pi, -- interlock to cost
1576: pay_assignment_actions pa1, -- cost assignment action
1577: pay_payroll_actions ppa1 -- cost payroll action
1578: WHERE pa.assignment_action_id = i_assignment_action_id

Line 1576: pay_assignment_actions pa1, -- cost assignment action

1572: c_payroll_action_id,
1573: c_action_type
1574: FROM pay_assignment_actions pa, -- TGL assignment action
1575: pay_action_interlocks pi, -- interlock to cost
1576: pay_assignment_actions pa1, -- cost assignment action
1577: pay_payroll_actions ppa1 -- cost payroll action
1578: WHERE pa.assignment_action_id = i_assignment_action_id
1579: AND pi.locking_action_id = pa.assignment_action_id
1580: AND pa1.assignment_action_id = pi.locked_action_id

Line 1599: FROM pay_assignment_actions pa, -- TGL assignment action

1595: INTO r_assignment_action_id,
1596: r_payroll_action_id,
1597: r_action_type,
1598: r_tax_unit_id
1599: FROM pay_assignment_actions pa, -- TGL assignment action
1600: pay_action_interlocks pi2, -- interlock to run
1601: pay_assignment_actions pa2, -- run assignment action
1602: pay_payroll_actions ppa2 -- run payroll action
1603: WHERE pa.assignment_action_id = i_assignment_action_id

Line 1601: pay_assignment_actions pa2, -- run assignment action

1597: r_action_type,
1598: r_tax_unit_id
1599: FROM pay_assignment_actions pa, -- TGL assignment action
1600: pay_action_interlocks pi2, -- interlock to run
1601: pay_assignment_actions pa2, -- run assignment action
1602: pay_payroll_actions ppa2 -- run payroll action
1603: WHERE pa.assignment_action_id = i_assignment_action_id
1604: AND pi2.locking_action_id = pa.assignment_action_id
1605: AND pa2.assignment_action_id = pi2.locked_action_id

Line 1626: pay_assignment_actions raa,

1622: decode (IV.uom, 'M', et.output_currency_code, 'STAT'),
1623: SUM(DECODE(cst.debit_or_credit,'D',cst.costed_value,0)),
1624: SUM(DECODE(cst.debit_or_credit,'C',cst.costed_value,0))
1625: FROM pay_payroll_actions ppa, -- run payroll action
1626: pay_assignment_actions raa,
1627: pay_costs cst,
1628: pay_run_results rr,
1629: pay_element_types_f et,
1630: pay_input_values_f IV

Line 1930: FROM pay_assignment_actions aa,

1926: AND (ppc.source_type not in ('P', 'U')
1927: OR (ppc.source_type in ('P', 'U')
1928: AND NOT EXISTS
1929: (SELECT 1
1930: FROM pay_assignment_actions aa,
1931: pay_payroll_actions pa,
1932: pay_pre_payments ppp,
1933: pay_org_payment_methods_f pom
1934: WHERE aa.pre_payment_id = ppc.pre_payment_id