DBA Data[Home] [Help]

APPS.GMS_COST_PLUS_EXTN dependencies on PA_EXPENDITURE_TYPES

Line 1059: from pa_expenditure_types pe

1055: -- To update expenditure_category and revenue category
1056: UPDATE gms_bc_packets pkt
1057: SET (pkt.expenditure_category,pkt.revenue_category) =
1058: (select pe.expenditure_category,pe.revenue_category_code
1059: from pa_expenditure_types pe
1060: where pe.expenditure_type = pkt.expenditure_type)
1061: WHERE pkt.packet_id = x_packet_id;
1062: END update_exp_rev_cat;
1063: -- ------------------------------------------------------------------------------------------------