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 252: FROM pay_payroll_actions ppa1, -- Cost pay actions

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

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

Line 262: pay_payroll_actions ppa -- Trans GL pay actions

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

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

422: into c_accounting_date,
423: c_run_date,
424: c_run_date_earned,
425: l_bus_grp_id
426: from pay_payroll_actions ppa1, -- Cost pay actions
427: pay_payroll_actions ppa2 -- Payroll run action
428: where ppa1.payroll_action_id = c_cost_action_id
429: and ppa2.payroll_action_id = c_run_action_id;
430: --

Line 427: pay_payroll_actions ppa2 -- Payroll run action

423: c_run_date,
424: c_run_date_earned,
425: l_bus_grp_id
426: from pay_payroll_actions ppa1, -- Cost pay actions
427: pay_payroll_actions ppa2 -- Payroll run action
428: where ppa1.payroll_action_id = c_cost_action_id
429: and ppa2.payroll_action_id = c_run_action_id;
430: --
431: hr_utility.set_location('pytrgl.trans_pay_costs',35);

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

534: :l_currency_type,
535: :c_conversion_date,
536: SUM(DECODE(cst.debit_or_credit,''D'',cst.costed_value,0)),
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

Line 539: pay_payroll_actions ppa1, -- Cost payroll action

535: :c_conversion_date,
536: SUM(DECODE(cst.debit_or_credit,''D'',cst.costed_value,0)),
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

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

738: :l_currency_type,
739: :c_conversion_date,
740: SUM(DECODE(cst.debit_or_credit,''D'',cst.costed_value,0)),
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

Line 743: pay_payroll_actions ppa1, -- Cost payroll action

739: :c_conversion_date,
740: SUM(DECODE(cst.debit_or_credit,''D'',cst.costed_value,0)),
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

Line 949: pay_payroll_actions ppa,

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

Line 952: pay_payroll_actions ppa2,

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

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

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

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

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

Line 1013: pay_payroll_actions ppa1 -- Cost pay actions

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
1016: --AND pa.action_status <> 'C'
1017: AND pi2.locking_action_id = pa.assignment_action_id

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

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

Line 1046: pay_payroll_actions ppa1, -- Cost pay actions

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

Line 1094: c_action_type pay_payroll_actions.action_type%TYPE;

1090: prev_sob_id NUMBER := 0;
1091: l_currency_type VARCHAR2(30);
1092: c_run_action_id NUMBER;
1093: c_cost_action_id NUMBER;
1094: c_action_type pay_payroll_actions.action_type%TYPE;
1095: c_payroll_id NUMBER;
1096: c_pay_id NUMBER;
1097: c_accounting_date DATE;
1098: c_conversion_date DATE;

Line 1141: pay_payroll_actions ppa

1137: --
1138: select bus.currency_code, bus.business_group_id
1139: into l_bus_currency_code, l_bus_grp_id
1140: from per_business_groups_perf bus,
1141: pay_payroll_actions ppa
1142: where ppa.payroll_action_id = i_payroll_action_id
1143: and bus.business_group_id = ppa.business_group_id;
1144: --
1145: hr_utility.set_location('pytrgl.trans_pay_costs',28);

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

1217: ppa2.date_earned
1218: into c_accounting_date,
1219: c_run_date,
1220: c_run_date_earned
1221: from pay_payroll_actions ppa1, -- Cost pay actions
1222: pay_payroll_actions ppa2 -- Payroll run action
1223: where ppa1.payroll_action_id = c_cost_action_id
1224: and ppa2.payroll_action_id = c_run_action_id;
1225:

Line 1222: pay_payroll_actions ppa2 -- Payroll run action

1218: into c_accounting_date,
1219: c_run_date,
1220: c_run_date_earned
1221: from pay_payroll_actions ppa1, -- Cost pay actions
1222: pay_payroll_actions ppa2 -- Payroll run action
1223: where ppa1.payroll_action_id = c_cost_action_id
1224: and ppa2.payroll_action_id = c_run_action_id;
1225:
1226: else

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

1228: -- costs overriden by contents of pay_gl_interface.accouting_date
1229: --
1230: select ppa1.effective_date, ppa1.effective_date
1231: into c_accounting_date, c_run_date
1232: from pay_payroll_actions ppa1 -- Estimate Cost pay action
1233: where ppa1.payroll_action_id = c_cost_action_id;
1234: end if;
1235:
1236: -- Avoid double postings for consolidation set estimate costs. Bug 5606113.

Line 1542: r_action_type pay_payroll_actions.action_type%TYPE;

1538: c_assignment_action_id NUMBER;
1539: r_assignment_action_id NUMBER;
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);

Line 1545: c_action_type pay_payroll_actions.action_type%TYPE;

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

Line 1577: pay_payroll_actions ppa1 -- cost payroll action

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

Line 1602: pay_payroll_actions ppa2 -- run payroll action

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

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

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

Line 1805: FROM pay_payroll_actions ppa,

1801: decode(l_date_used, 'E', ptp.end_date,
1802: 'EVE', ptp.end_date,
1803: ptp.pay_advice_date + pay.pay_date_offset)
1804: INTO l_accounting_date
1805: FROM pay_payroll_actions ppa,
1806: per_all_assignments_f pera,
1807: pay_all_payrolls_f pay,
1808: per_time_periods ptp
1809: WHERE ppa.payroll_action_id = c_payroll_action_id

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

1834: decode (IV.uom, 'M', et.output_currency_code, 'STAT'),
1835: SUM(DECODE(cst.debit_or_credit,'D',cst.costed_value,0)),
1836: SUM(DECODE(cst.debit_or_credit,'C',cst.costed_value,0)),
1837: decode (CST.source_id, null, null, l_accounting_date)
1838: FROM pay_payroll_actions ppa, -- TGL payroll action
1839: pay_costs cst,
1840: pay_input_values_f IV,
1841: pay_element_types_f et
1842: WHERE ppa.payroll_action_id = t_payroll_action_id

Line 1931: pay_payroll_actions pa,

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