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 260: pay_assignment_actions pa1, -- Cost asg actions.

256: ppa1.payroll_action_id,
257: pp.payroll_id,
258: pp.gl_set_of_books_id
259: FROM pay_payroll_actions ppa1, -- Cost pay actions
260: pay_assignment_actions pa1, -- Cost asg actions.
261: pay_action_interlocks pi3, -- Cost - Run
262: pay_action_interlocks pi1, -- Cost - Trans GL
263: pay_all_payrolls_f pp,
264: pay_action_classifications pac,

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

262: pay_action_interlocks pi1, -- Cost - Trans GL
263: pay_all_payrolls_f pp,
264: pay_action_classifications pac,
265: pay_payroll_actions ppa2, -- Payroll run actions.
266: pay_assignment_actions pa2, -- Payroll run asg actions.
267: pay_action_interlocks pi2, -- Run - Trans GL
268: pay_assignment_actions pa, -- Trans GL asg actions
269: pay_payroll_actions ppa -- Trans GL pay actions
270: WHERE ppa.payroll_action_id = i_action_id

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

264: pay_action_classifications pac,
265: pay_payroll_actions ppa2, -- Payroll run actions.
266: pay_assignment_actions pa2, -- Payroll run asg actions.
267: pay_action_interlocks pi2, -- Run - Trans GL
268: pay_assignment_actions pa, -- Trans GL asg actions
269: pay_payroll_actions ppa -- Trans GL pay actions
270: WHERE ppa.payroll_action_id = i_action_id
271: AND pa.payroll_action_id = ppa.payroll_action_id
272: AND pa.action_status <> 'C'

Line 548: pay_assignment_actions pa, -- TGL assignment action

544: SUM(DECODE(cst.debit_or_credit,''C'',cst.costed_value,null))
545: FROM pay_payroll_actions ppa, -- Run payroll action
546: pay_payroll_actions ppa1, -- Cost payroll action
547: per_all_assignments_f per,
548: pay_assignment_actions pa, -- TGL assignment action
549: pay_action_interlocks pi, -- interlock to costing
550: pay_assignment_actions pa1, -- Cost assignment action
551: pay_action_interlocks pi2, -- interlock to run
552: pay_assignment_actions pa3, -- run master assignment action

Line 550: pay_assignment_actions pa1, -- Cost assignment action

546: pay_payroll_actions ppa1, -- Cost payroll action
547: per_all_assignments_f per,
548: pay_assignment_actions pa, -- TGL assignment action
549: pay_action_interlocks pi, -- interlock to costing
550: pay_assignment_actions pa1, -- Cost assignment action
551: pay_action_interlocks pi2, -- interlock to run
552: pay_assignment_actions pa3, -- run master assignment action
553: pay_assignment_actions pa2, -- run assignment action
554: pay_costs cst,

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

548: pay_assignment_actions pa, -- TGL assignment action
549: pay_action_interlocks pi, -- interlock to costing
550: pay_assignment_actions pa1, -- Cost assignment action
551: pay_action_interlocks pi2, -- interlock to run
552: pay_assignment_actions pa3, -- run master assignment action
553: pay_assignment_actions pa2, -- run assignment action
554: pay_costs cst,
555: pay_cost_allocation_keyflex caf,
556: pay_run_results rr,

Line 553: pay_assignment_actions pa2, -- run assignment action

549: pay_action_interlocks pi, -- interlock to costing
550: pay_assignment_actions pa1, -- Cost assignment action
551: pay_action_interlocks pi2, -- interlock to run
552: pay_assignment_actions pa3, -- run master assignment action
553: pay_assignment_actions pa2, -- run assignment action
554: pay_costs cst,
555: pay_cost_allocation_keyflex caf,
556: pay_run_results rr,
557: pay_input_values_f IV,

Line 752: pay_assignment_actions pa, -- TGL assignment action

748: SUM(DECODE(cst.debit_or_credit,''C'',cst.costed_value,null))
749: FROM pay_payroll_actions ppa, -- Run payroll action
750: pay_payroll_actions ppa1, -- Cost payroll action
751: per_all_assignments_f per,
752: pay_assignment_actions pa, -- TGL assignment action
753: pay_action_interlocks pi, -- interlock to costing
754: pay_assignment_actions pa1, -- Cost assignment action
755: pay_action_interlocks pi2, -- interlock to run
756: pay_assignment_actions pa3, -- run master assignment action

Line 754: pay_assignment_actions pa1, -- Cost assignment action

750: pay_payroll_actions ppa1, -- Cost payroll action
751: per_all_assignments_f per,
752: pay_assignment_actions pa, -- TGL assignment action
753: pay_action_interlocks pi, -- interlock to costing
754: pay_assignment_actions pa1, -- Cost assignment action
755: pay_action_interlocks pi2, -- interlock to run
756: pay_assignment_actions pa3, -- run master assignment action
757: pay_assignment_actions pa2, -- run assignment action
758: pay_costs cst,

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

752: pay_assignment_actions pa, -- TGL assignment action
753: pay_action_interlocks pi, -- interlock to costing
754: pay_assignment_actions pa1, -- Cost assignment action
755: pay_action_interlocks pi2, -- interlock to run
756: pay_assignment_actions pa3, -- run master assignment action
757: pay_assignment_actions pa2, -- run assignment action
758: pay_costs cst,
759: pay_cost_allocation_keyflex caf,
760: pay_run_results rr,

Line 757: pay_assignment_actions pa2, -- run assignment action

753: pay_action_interlocks pi, -- interlock to costing
754: pay_assignment_actions pa1, -- Cost assignment action
755: pay_action_interlocks pi2, -- interlock to run
756: pay_assignment_actions pa3, -- run master assignment action
757: pay_assignment_actions pa2, -- run assignment action
758: pay_costs cst,
759: pay_cost_allocation_keyflex caf,
760: pay_run_results rr,
761: pay_input_values_f IV,

Line 947: UPDATE pay_assignment_actions pa

943: hr_utility.set_location('pytrgl.trans_pay_costs',90);
944: --
945: -- Update the assignment actions. Mark as processed.
946: --
947: UPDATE pay_assignment_actions pa
948: SET pa.action_status = 'C'
949: WHERE pa.action_status <> 'C'
950: AND pa.payroll_action_id = i_payroll_action_id
951: AND EXISTS

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

954: NULL
955: FROM
956: pay_payroll_actions ppa,
957: pay_action_interlocks pi2, -- Run - Trans GL
958: pay_assignment_actions pa2, -- Payroll run actions.
959: pay_payroll_actions ppa2,
960: per_all_assignments_f per
961: WHERE pi2.locking_action_id = pa.assignment_action_id
962: AND pa.assignment_id = per.assignment_id

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

1007: pp.payroll_id,
1008: pp.gl_set_of_books_id,
1009: ppa1.payroll_id
1010: FROM pay_payroll_actions ppa, -- Trans GL pay actions
1011: pay_assignment_actions pa, -- Trans GL asg actions
1012: pay_action_interlocks pi2, -- Run - Trans GL
1013: pay_assignment_actions pa2, -- Payroll run asg actions.
1014: pay_payroll_actions ppa2, -- Payroll run actions.
1015: pay_action_classifications pac,

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

1009: ppa1.payroll_id
1010: FROM pay_payroll_actions ppa, -- Trans GL pay actions
1011: pay_assignment_actions pa, -- Trans GL asg actions
1012: pay_action_interlocks pi2, -- Run - Trans GL
1013: pay_assignment_actions pa2, -- Payroll run asg actions.
1014: pay_payroll_actions ppa2, -- Payroll run actions.
1015: pay_action_classifications pac,
1016: pay_all_payrolls_f pp,
1017: pay_action_interlocks pi1, -- Cost - Trans GL

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

1014: pay_payroll_actions ppa2, -- Payroll run actions.
1015: pay_action_classifications pac,
1016: pay_all_payrolls_f pp,
1017: pay_action_interlocks pi1, -- Cost - Trans GL
1018: pay_assignment_actions pa1, -- Cost asg actions.
1019: pay_action_interlocks pi3, -- Cost - Run
1020: pay_payroll_actions ppa1, -- Cost pay actions
1021: (select distinct
1022: gl.assignment_action_id,

Line 1025: pay_assignment_actions aa

1021: (select distinct
1022: gl.assignment_action_id,
1023: run_payroll_action_id
1024: from pay_gl_interface gl,
1025: pay_assignment_actions aa
1026: where gl.assignment_action_id = aa.assignment_action_id
1027: and aa.payroll_action_id = i_action_id) gl
1028: -- Checking with GL 6848762*/
1029: WHERE ppa.payroll_action_id = i_action_id

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

1058: pp.payroll_id,
1059: pp.gl_set_of_books_id,
1060: ppa1.payroll_id
1061: FROM pay_payroll_actions ppa, -- Trans GL pay actions
1062: pay_assignment_actions pa, -- Trans GL asg actions
1063: pay_action_interlocks pi1, -- Cost - Trans GL
1064: pay_assignment_actions pa1, -- Cost asg actions
1065: pay_payroll_actions ppa1, -- Cost pay actions
1066: per_all_assignments_f pera,

Line 1064: pay_assignment_actions pa1, -- Cost asg actions

1060: ppa1.payroll_id
1061: FROM pay_payroll_actions ppa, -- Trans GL pay actions
1062: pay_assignment_actions pa, -- Trans GL asg actions
1063: pay_action_interlocks pi1, -- Cost - Trans GL
1064: pay_assignment_actions pa1, -- Cost asg actions
1065: pay_payroll_actions ppa1, -- Cost pay actions
1066: per_all_assignments_f pera,
1067: pay_all_payrolls_f pp
1068: WHERE ppa.payroll_action_id = i_action_id

Line 1400: FROM pay_assignment_actions pa,

1396: :l_currency_type,
1397: :c_conversion_date,
1398: SUM(pgl.entered_dr),
1399: SUM(pgl.entered_cr)
1400: FROM pay_assignment_actions pa,
1401: '|| l_asg_tab ||'
1402: pay_action_interlocks int,
1403: pay_assignment_actions pa2,
1404: pay_gl_interface pgl,

Line 1403: pay_assignment_actions pa2,

1399: SUM(pgl.entered_cr)
1400: FROM pay_assignment_actions pa,
1401: '|| l_asg_tab ||'
1402: pay_action_interlocks int,
1403: pay_assignment_actions pa2,
1404: pay_gl_interface pgl,
1405: pay_cost_allocation_keyflex caf
1406: WHERE pgl.run_payroll_action_id = :c_run_action_id
1407: '|| l_asg_join ||'

Line 1469: FROM pay_assignment_actions pa,

1465: :l_currency_type,
1466: :c_conversion_date,
1467: SUM(pgl.entered_dr),
1468: SUM(pgl.entered_cr)
1469: FROM pay_assignment_actions pa,
1470: '|| l_asg_tab ||'
1471: pay_action_interlocks int,
1472: pay_assignment_actions pa2,
1473: pay_gl_interface pgl,

Line 1472: pay_assignment_actions pa2,

1468: SUM(pgl.entered_cr)
1469: FROM pay_assignment_actions pa,
1470: '|| l_asg_tab ||'
1471: pay_action_interlocks int,
1472: pay_assignment_actions pa2,
1473: pay_gl_interface pgl,
1474: pay_cost_allocation_keyflex caf
1475: WHERE pgl.run_payroll_action_id = :c_run_action_id
1476: '|| l_asg_join ||'

Line 1563: r_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

1559: c_payroll_action_id NUMBER;
1560: r_payroll_action_id NUMBER;
1561: r_action_type pay_payroll_actions.action_type%TYPE;
1562: r_assignment_id NUMBER;
1563: r_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
1564: c_action_type pay_payroll_actions.action_type%TYPE;
1565: l_date_used VARCHAR2(80);
1566: l_accounting_date DATE;
1567: BEGIN

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

1589: r_assignment_id,
1590: c_assignment_action_id,
1591: c_payroll_action_id,
1592: c_action_type
1593: FROM pay_assignment_actions pa, -- TGL assignment action
1594: pay_action_interlocks pi, -- interlock to cost
1595: pay_assignment_actions pa1, -- cost assignment action
1596: pay_payroll_actions ppa1 -- cost payroll action
1597: WHERE pa.assignment_action_id = i_assignment_action_id

Line 1595: pay_assignment_actions pa1, -- cost assignment action

1591: c_payroll_action_id,
1592: c_action_type
1593: FROM pay_assignment_actions pa, -- TGL assignment action
1594: pay_action_interlocks pi, -- interlock to cost
1595: pay_assignment_actions pa1, -- cost assignment action
1596: pay_payroll_actions ppa1 -- cost payroll action
1597: WHERE pa.assignment_action_id = i_assignment_action_id
1598: AND pi.locking_action_id = pa.assignment_action_id
1599: AND pa1.assignment_action_id = pi.locked_action_id

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

1614: INTO r_assignment_action_id,
1615: r_payroll_action_id,
1616: r_action_type,
1617: r_tax_unit_id
1618: FROM pay_assignment_actions pa, -- TGL assignment action
1619: pay_action_interlocks pi2, -- interlock to run
1620: pay_assignment_actions pa2, -- run assignment action
1621: pay_payroll_actions ppa2 -- run payroll action
1622: WHERE pa.assignment_action_id = i_assignment_action_id

Line 1620: pay_assignment_actions pa2, -- run assignment action

1616: r_action_type,
1617: r_tax_unit_id
1618: FROM pay_assignment_actions pa, -- TGL assignment action
1619: pay_action_interlocks pi2, -- interlock to run
1620: pay_assignment_actions pa2, -- run assignment action
1621: pay_payroll_actions ppa2 -- run payroll action
1622: WHERE pa.assignment_action_id = i_assignment_action_id
1623: AND pi2.locking_action_id = pa.assignment_action_id
1624: AND pa2.assignment_action_id = pi2.locked_action_id

Line 1645: pay_assignment_actions raa,

1641: decode (IV.uom, 'M', et.output_currency_code, 'STAT'),
1642: SUM(DECODE(cst.debit_or_credit,'D',cst.costed_value,null)),
1643: SUM(DECODE(cst.debit_or_credit,'C',cst.costed_value,null))
1644: FROM pay_payroll_actions ppa, -- run payroll action
1645: pay_assignment_actions raa,
1646: pay_costs cst,
1647: pay_run_results rr,
1648: pay_element_types_f et,
1649: pay_input_values_f IV

Line 1949: FROM pay_assignment_actions aa,

1945: AND (ppc.source_type not in ('P', 'U')
1946: OR (ppc.source_type in ('P', 'U')
1947: AND NOT EXISTS
1948: (SELECT 1
1949: FROM pay_assignment_actions aa,
1950: pay_payroll_actions pa,
1951: pay_pre_payments ppp,
1952: pay_org_payment_methods_f pom
1953: WHERE aa.pre_payment_id = ppc.pre_payment_id