DBA Data[Home] [Help]

APPS.PAY_SLA_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 250: FROM per_all_assignments_f pera,

246: (pera.payroll_id, c_effective_date),
247: pap.gl_set_of_books_id
248: INTO l_rev_accounting_date,
249: l_ledger_id
250: FROM per_all_assignments_f pera,
251: pay_all_payrolls_f pap
252: WHERE pera.assignment_id = r_assignment_id
253: AND c_effective_date BETWEEN pera.effective_start_date
254: AND pera.effective_end_date

Line 321: FROM per_all_assignments_f pera,

317: --
318:
319: SELECT pap.gl_set_of_books_id
320: INTO l_ledger_id
321: FROM per_all_assignments_f pera,
322: pay_all_payrolls_f pap
323: WHERE pera.assignment_id = r_assignment_id
324: AND c_effective_date BETWEEN pera.effective_start_date
325: AND pera.effective_end_date

Line 705: per_all_assignments_f paf

701: pay_action_interlocks pi, -- interlock to run
702: pay_assignment_actions pa1, -- run assignment action
703: pay_payroll_actions ppa1,-- run payroll action
704: pay_all_payrolls_f pap,
705: per_all_assignments_f paf
706: WHERE pa.assignment_action_id = i_assignment_action_id
707: AND pi.locking_action_id = pa.assignment_action_id
708: AND pa1.assignment_action_id = pi.locked_action_id
709: AND ppa1.payroll_action_id = pa1.payroll_action_id