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_PAYROLL_ACTIONS

Line 259: FROM pay_payroll_actions ppa1, -- Cost pay actions

255: SELECT DISTINCT ppa2.payroll_action_id,
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,

Line 265: pay_payroll_actions ppa2, -- Payroll run 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,
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

Line 269: pay_payroll_actions ppa -- Trans GL pay actions

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'
273: AND pi2.locking_action_id = pa.assignment_action_id

Line 433: from pay_payroll_actions ppa1, -- Cost pay actions

429: into c_accounting_date,
430: c_run_date,
431: c_run_date_earned,
432: l_bus_grp_id
433: from pay_payroll_actions ppa1, -- Cost pay actions
434: pay_payroll_actions ppa2 -- Payroll run action
435: where ppa1.payroll_action_id = c_cost_action_id
436: and ppa2.payroll_action_id = c_run_action_id;
437: --

Line 434: pay_payroll_actions ppa2 -- Payroll run action

430: c_run_date,
431: c_run_date_earned,
432: l_bus_grp_id
433: from pay_payroll_actions ppa1, -- Cost pay actions
434: pay_payroll_actions ppa2 -- Payroll run action
435: where ppa1.payroll_action_id = c_cost_action_id
436: and ppa2.payroll_action_id = c_run_action_id;
437: --
438: hr_utility.set_location('pytrgl.trans_pay_costs',35);

Line 545: FROM pay_payroll_actions ppa, -- Run payroll action

541: :l_currency_type,
542: :c_conversion_date,
543: SUM(DECODE(cst.debit_or_credit,''D'',cst.costed_value,null)),
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

Line 546: pay_payroll_actions ppa1, -- Cost payroll action

542: :c_conversion_date,
543: SUM(DECODE(cst.debit_or_credit,''D'',cst.costed_value,null)),
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

Line 749: FROM pay_payroll_actions ppa, -- Run payroll action

745: :l_currency_type,
746: :c_conversion_date,
747: SUM(DECODE(cst.debit_or_credit,''D'',cst.costed_value,null)),
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

Line 750: pay_payroll_actions ppa1, -- Cost payroll action

746: :c_conversion_date,
747: SUM(DECODE(cst.debit_or_credit,''D'',cst.costed_value,null)),
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

Line 956: pay_payroll_actions ppa,

952: (SELECT /*+ ORDERED
953: USE_NL (ppa pi2 pa2 per) */
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

Line 959: pay_payroll_actions ppa2,

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
963: AND per.payroll_id +0 = c_payroll_id

Line 1010: FROM pay_payroll_actions ppa, -- Trans GL pay actions

1006: ppa1.action_type,
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.

Line 1014: pay_payroll_actions ppa2, -- Payroll run actions.

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

Line 1020: pay_payroll_actions ppa1, -- Cost pay actions

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,
1023: run_payroll_action_id
1024: from pay_gl_interface gl,

Line 1061: FROM pay_payroll_actions ppa, -- Trans GL pay actions

1057: ppa1.action_type,
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

Line 1065: pay_payroll_actions ppa1, -- Cost pay actions

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
1069: AND pa.payroll_action_id = ppa.payroll_action_id

Line 1113: c_action_type pay_payroll_actions.action_type%TYPE;

1109: prev_sob_id NUMBER := 0;
1110: l_currency_type VARCHAR2(30);
1111: c_run_action_id NUMBER;
1112: c_cost_action_id NUMBER;
1113: c_action_type pay_payroll_actions.action_type%TYPE;
1114: c_payroll_id NUMBER;
1115: c_pay_id NUMBER;
1116: c_accounting_date DATE;
1117: c_conversion_date DATE;

Line 1160: pay_payroll_actions ppa

1156: --
1157: select bus.currency_code, bus.business_group_id
1158: into l_bus_currency_code, l_bus_grp_id
1159: from per_business_groups_perf bus,
1160: pay_payroll_actions ppa
1161: where ppa.payroll_action_id = i_payroll_action_id
1162: and bus.business_group_id = ppa.business_group_id;
1163: --
1164: hr_utility.set_location('pytrgl.trans_pay_costs',28);

Line 1240: from pay_payroll_actions ppa1, -- Cost pay actions

1236: ppa2.date_earned
1237: into c_accounting_date,
1238: c_run_date,
1239: c_run_date_earned
1240: from pay_payroll_actions ppa1, -- Cost pay actions
1241: pay_payroll_actions ppa2 -- Payroll run action
1242: where ppa1.payroll_action_id = c_cost_action_id
1243: and ppa2.payroll_action_id = c_run_action_id;
1244:

Line 1241: pay_payroll_actions ppa2 -- Payroll run action

1237: into c_accounting_date,
1238: c_run_date,
1239: c_run_date_earned
1240: from pay_payroll_actions ppa1, -- Cost pay actions
1241: pay_payroll_actions ppa2 -- Payroll run action
1242: where ppa1.payroll_action_id = c_cost_action_id
1243: and ppa2.payroll_action_id = c_run_action_id;
1244:
1245: else

Line 1251: from pay_payroll_actions ppa1 -- Estimate Cost pay action

1247: -- costs overriden by contents of pay_gl_interface.accouting_date
1248: --
1249: select ppa1.effective_date, ppa1.effective_date
1250: into c_accounting_date, c_run_date
1251: from pay_payroll_actions ppa1 -- Estimate Cost pay action
1252: where ppa1.payroll_action_id = c_cost_action_id;
1253: end if;
1254:
1255: -- Avoid double postings for consolidation set estimate costs. Bug 5606113.

Line 1561: r_action_type pay_payroll_actions.action_type%TYPE;

1557: c_assignment_action_id NUMBER;
1558: r_assignment_action_id NUMBER;
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);

Line 1564: c_action_type pay_payroll_actions.action_type%TYPE;

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
1568: --

Line 1596: pay_payroll_actions ppa1 -- cost payroll action

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
1600: AND ppa1.payroll_action_id = pa1.payroll_action_id

Line 1621: pay_payroll_actions ppa2 -- run payroll action

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
1625: AND ppa2.payroll_action_id = pa2.payroll_action_id

Line 1644: FROM pay_payroll_actions ppa, -- run payroll action

1640: cst.cost_allocation_keyflex_id,
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,

Line 1824: FROM pay_payroll_actions ppa,

1820: decode(l_date_used, 'E', ptp.end_date,
1821: 'EVE', ptp.end_date,
1822: ptp.pay_advice_date + pay.pay_date_offset)
1823: INTO l_accounting_date
1824: FROM pay_payroll_actions ppa,
1825: per_all_assignments_f pera,
1826: pay_all_payrolls_f pay,
1827: per_time_periods ptp
1828: WHERE ppa.payroll_action_id = c_payroll_action_id

Line 1857: FROM pay_payroll_actions ppa, -- TGL payroll action

1853: decode (IV.uom, 'M', et.output_currency_code, 'STAT'),
1854: SUM(DECODE(cst.debit_or_credit,'D',cst.costed_value,null)),
1855: SUM(DECODE(cst.debit_or_credit,'C',cst.costed_value,null)),
1856: decode (CST.source_id, null, null, l_accounting_date)
1857: FROM pay_payroll_actions ppa, -- TGL payroll action
1858: pay_costs cst,
1859: pay_input_values_f IV,
1860: pay_element_types_f et
1861: WHERE ppa.payroll_action_id = t_payroll_action_id

Line 1950: pay_payroll_actions pa,

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
1954: AND pa.payroll_action_id = aa.payroll_action_id