APPS.PAY_BATCH_BALANCE_ADJ_PKG dependencies on PAY_CONSOLIDATION_SETS

Line 621: dummy_consolidation_id pay_consolidation_sets.consolidation_set_id%type;

617: status_T number := 0;
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

Line 711: from pay_consolidation_sets pcs

707: -- are valid or not. If not valid then raise exception here
708: --
709: begin
710: select pcs.consolidation_set_id into dummy_consolidation_id
711: from pay_consolidation_sets pcs
712: where group_csr.consolidation_set_id = pcs.consolidation_set_id;
713: exception
714: when no_data_found then
715: raise invalid_batch_group_details;