APPS.PAY_TRGL_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 254: pay_action_interlocks pi3, -- Cost - Run

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

Line 255: pay_action_interlocks pi1, -- Cost - Trans GL

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,
258: pay_payroll_actions ppa2, -- Payroll run actions.
259: pay_assignment_actions pa2, -- Payroll run asg actions.

Line 260: pay_action_interlocks pi2, -- Run - 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
264: AND pa.payroll_action_id = ppa.payroll_action_id

Line 542: pay_action_interlocks pi, -- interlock to costing

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
546: pay_assignment_actions pa2, -- run assignment action

Line 544: pay_action_interlocks pi2, -- interlock to run

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,
548: pay_cost_allocation_keyflex caf,

Line 746: pay_action_interlocks pi, -- interlock to costing

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
750: pay_assignment_actions pa2, -- run assignment action

Line 748: pay_action_interlocks pi2, -- interlock to run

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,
752: pay_cost_allocation_keyflex caf,

Line 950: pay_action_interlocks pi2, -- Run - Trans GL

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
954: WHERE pi2.locking_action_id = pa.assignment_action_id

Line 1005: pay_action_interlocks pi2, -- Run - Trans GL

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,
1009: pay_all_payrolls_f pp,

Line 1010: pay_action_interlocks pi1, -- Cost - 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.
1012: pay_action_interlocks pi3, -- Cost - Run
1013: pay_payroll_actions ppa1 -- Cost pay actions
1014: WHERE ppa.payroll_action_id = i_action_id

Line 1012: pay_action_interlocks pi3, -- Cost - Run

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
1016: --AND pa.action_status <> 'C'

Line 1044: pay_action_interlocks pi1, -- Cost - Trans GL

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,
1048: pay_all_payrolls_f pp

Line 1356: INDEX(int PAY_ACTION_INTERLOCKS_PK)

1352: entered_dr,
1353: entered_cr)
1354: SELECT /*+ ORDERED
1355: INDEX(paf PER_ASSIGNMENTS_F_PK)
1356: INDEX(int PAY_ACTION_INTERLOCKS_PK)
1357: INDEX(pgl PAY_GL_INTERFACE_N1)
1358: USE_NL(pgl int pa pa2 paf) */
1359: ''NEW'',
1360: :c_set_of_books_id,

Line 1383: pay_action_interlocks int,

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,
1386: pay_cost_allocation_keyflex caf
1387: WHERE pgl.run_payroll_action_id = :c_run_action_id

Line 1426: INDEX(int PAY_ACTION_INTERLOCKS_PK)

1422: entered_dr,
1423: entered_cr)
1424: SELECT /*+ ORDERED
1425: INDEX(paf PER_ASSIGNMENTS_F_PK)
1426: INDEX(int PAY_ACTION_INTERLOCKS_PK)
1427: INDEX(pgl PAY_GL_INTERFACE_N1)
1428: USE_NL(pgl int pa pa2 paf) */
1429: ''NEW'',
1430: :c_set_of_books_id,

Line 1452: pay_action_interlocks int,

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,
1455: pay_cost_allocation_keyflex caf
1456: WHERE pgl.run_payroll_action_id = :c_run_action_id

Line 1575: pay_action_interlocks pi, -- interlock to cost

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
1579: AND pi.locking_action_id = pa.assignment_action_id

Line 1600: pay_action_interlocks pi2, -- interlock to run

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