APPS.PSP_SUM_ADJ dependencies on GMS_AWARD_DISTRIBUTIONS

Line 3951: delete gms_award_distributions

3947: CLOSE group_name_cur;
3948:
3949: if l_exp_group_name is not null then
3950:
3951: delete gms_award_distributions
3952: where document_type = 'EXP'
3953: and expenditure_item_id in
3954: ( select expenditure_item_id
3955: from pa_expenditure_items_all

Line 3962: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' deleted from gms_award_distributions count: '||sql%rowcount);

3958: (select expenditure_id
3959: from pa_expenditures_all
3960: where expenditure_group = l_exp_group_name));
3961:
3962: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' deleted from gms_award_distributions count: '||sql%rowcount);
3963:
3964: delete pa_expenditure_items_all
3965: where transaction_source in ('OLD','GOLD')
3966: and expenditure_id in

Line 4501: delete gms_award_distributions

4497:
4498: if (l_gms_phase = 'GMS_Tie_Back') then
4499: -- Rearranged the Delete statments, so as to delete items first and tuned DEL exp stmt for 2133056
4500:
4501: delete gms_award_distributions
4502: where document_type = 'EXP'
4503: and expenditure_item_id in
4504: (select expenditure_item_id
4505: from pa_expenditure_items_all