APPS.PAY_BATCH_BALANCE_ADJ_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 622: dummy_payroll_id pay_all_payrolls_f.payroll_id%type;

618: status_E number := 0;
619: l_element_link_id number := 0;
620:
621: dummy_consolidation_id pay_consolidation_sets.consolidation_set_id%type;
622: dummy_payroll_id pay_all_payrolls_f.payroll_id%type;
623: dummy_msg_source_id pay_message_lines.source_id%type;
624:
625: -- Temperorary table for storing error messages and used for later putting into
626: -- pay_message_lines

Line 722: from pay_all_payrolls_f papf

718: -- invalid consolidation_set_id,.... raising Exception
719:
720: begin
721: select papf.payroll_id into dummy_payroll_id
722: from pay_all_payrolls_f papf
723: where group_csr.payroll_id = papf.payroll_id
724: AND group_csr.effective_date between
725: papf.effective_start_date and papf.effective_end_date;
726: exception