DBA Data[Home] [Help]

APPS.PAY_BATCH_BALANCEADJ_WRAPPER dependencies on PAY_PAYROLLS_F

Line 664: from per_assignments_f paf, pay_payrolls_f ppf, pay_consolidation_sets pcs

660: -- Bug: 5079557
661:
662: cursor c_get_consolidation_set_id IS
663: select pcs.consolidation_set_id
664: from per_assignments_f paf, pay_payrolls_f ppf, pay_consolidation_sets pcs
665: where paf.assignment_number = p_assignment_id
666: and paf.business_group_id = p_business_group_id
667: and sysdate between paf.effective_start_date and paf.effective_end_date
668: and paf.payroll_id = ppf.payroll_id