DBA Data[Home] [Help]

APPS.PAY_SLA_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 240: FROM per_all_assignments_f pera,

236: (pera.payroll_id, c_effective_date),
237: pap.gl_set_of_books_id
238: INTO l_rev_accounting_date,
239: l_ledger_id
240: FROM per_all_assignments_f pera,
241: pay_all_payrolls_f pap
242: WHERE pera.assignment_id = r_assignment_id
243: AND c_effective_date BETWEEN pera.effective_start_date
244: AND pera.effective_end_date

Line 311: FROM per_all_assignments_f pera,

307: --
308:
309: SELECT pap.gl_set_of_books_id
310: INTO l_ledger_id
311: FROM per_all_assignments_f pera,
312: pay_all_payrolls_f pap
313: WHERE pera.assignment_id = r_assignment_id
314: AND c_effective_date BETWEEN pera.effective_start_date
315: AND pera.effective_end_date