APPS.PSP_SUM_ADJ dependencies on GMS_AWARD_DISTRIBUTIONS

Line 3579: delete gms_award_distributions

3575: CLOSE group_name_cur;
3576:
3577: if l_exp_group_name is not null then
3578:
3579: delete gms_award_distributions
3580: where document_type = 'EXP'
3581: and expenditure_item_id in
3582: ( select expenditure_item_id
3583: from pa_expenditure_items_all

Line 4070: delete gms_award_distributions

4066:
4067: if (l_gms_phase = 'GMS_Tie_Back') then
4068: -- Rearranged the Delete statments, so as to delete items first and tuned DEL exp stmt for 2133056
4069:
4070: delete gms_award_distributions
4071: where document_type = 'EXP'
4072: and expenditure_item_id in
4073: (select expenditure_item_id
4074: from pa_expenditure_items_all