DBA Data[Home] [Help]

APPS.GMS_COST_PLUS_EXTN dependencies on PA_EXPENDITURE_TYPES

Line 792: from pa_expenditure_types pe

788: -- To update expenditure_category and revenue category
789: UPDATE gms_bc_packets pkt
790: SET (pkt.expenditure_category,pkt.revenue_category) =
791: (select pe.expenditure_category,pe.revenue_category_code
792: from pa_expenditure_types pe
793: where pe.expenditure_type = pkt.expenditure_type)
794: WHERE pkt.packet_id = x_packet_id;
795: END update_exp_rev_cat;
796: -- ------------------------------------------------------------------------------------------------