DBA Data[Home] [Help]

APPS.PAY_TRGL_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 256: pay_all_payrolls_f pp,

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.
260: pay_action_interlocks pi2, -- Run - Trans GL

Line 1009: pay_all_payrolls_f pp,

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.
1012: pay_action_interlocks pi3, -- Cost - Run
1013: pay_payroll_actions ppa1 -- Cost pay actions

Line 1048: pay_all_payrolls_f pp

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
1051: AND pi1.locking_action_id = pa.assignment_action_id
1052: AND pa1.assignment_action_id = pi1.locked_action_id

Line 1807: pay_all_payrolls_f pay,

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
1810: AND pera.assignment_id = r_assignment_id
1811: AND ppa.effective_date BETWEEN pera.effective_start_date