APPS.PAY_TRGL_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 261: pay_action_interlocks pi3, -- Cost - Run

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

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

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

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

Line 549: pay_action_interlocks pi, -- interlock to costing

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

Line 551: pay_action_interlocks pi2, -- interlock to run

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

Line 753: pay_action_interlocks pi, -- interlock to costing

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

Line 755: pay_action_interlocks pi2, -- interlock to run

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

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

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

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

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

Line 1017: pay_action_interlocks pi1, -- Cost - 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.
1019: pay_action_interlocks pi3, -- Cost - Run
1020: pay_payroll_actions ppa1, -- Cost pay actions
1021: (select distinct

Line 1019: pay_action_interlocks pi3, -- Cost - Run

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,
1023: run_payroll_action_id

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

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

Line 1375: INDEX(int PAY_ACTION_INTERLOCKS_PK)

1371: entered_dr,
1372: entered_cr)
1373: SELECT /*+ ORDERED
1374: INDEX(paf PER_ASSIGNMENTS_F_PK)
1375: INDEX(int PAY_ACTION_INTERLOCKS_PK)
1376: INDEX(pgl PAY_GL_INTERFACE_N1)
1377: USE_NL(pgl int pa pa2 paf) */
1378: ''NEW'',
1379: :c_set_of_books_id,

Line 1402: pay_action_interlocks int,

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

Line 1445: INDEX(int PAY_ACTION_INTERLOCKS_PK)

1441: entered_dr,
1442: entered_cr)
1443: SELECT /*+ ORDERED
1444: INDEX(paf PER_ASSIGNMENTS_F_PK)
1445: INDEX(int PAY_ACTION_INTERLOCKS_PK)
1446: INDEX(pgl PAY_GL_INTERFACE_N1)
1447: USE_NL(pgl int pa pa2 paf) */
1448: ''NEW'',
1449: :c_set_of_books_id,

Line 1471: pay_action_interlocks int,

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

Line 1594: pay_action_interlocks pi, -- interlock to cost

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

Line 1619: pay_action_interlocks pi2, -- interlock to run

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