DBA Data[Home] [Help]

APPS.PAY_TRGL_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 263: pay_all_payrolls_f pp,

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

Line 1016: pay_all_payrolls_f pp,

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

Line 1067: pay_all_payrolls_f pp

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

Line 1826: pay_all_payrolls_f pay,

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