APPS.PSP_SUM_ADJ dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 3955: from pa_expenditure_items_all

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
3956: where transaction_source = 'GOLD'
3957: and expenditure_id in
3958: (select expenditure_id
3959: from pa_expenditures_all

Line 3964: delete pa_expenditure_items_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
3967: (select expenditure_id
3968: from pa_expenditures_all

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

3967: (select expenditure_id
3968: from pa_expenditures_all
3969: where expenditure_group = l_exp_group_name);
3970:
3971: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' deleted from pa_expenditure_items_all count: '||sql%rowcount);
3972:
3973: delete pa_expenditures_all
3974: where expenditure_group = l_exp_group_name;
3975:

Line 4505: from pa_expenditure_items_all

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
4506: where transaction_source = 'GOLD'
4507: and orig_transaction_reference in
4508: (select to_char(summary_line_id)
4509: from psp_summary_lines

Line 4517: delete from pa_expenditure_items_all

4513: where batch_name = l_batch_name
4514: and source_type='A'))); ----- Added this delete for Bug 2133056
4515:
4516:
4517: delete from pa_expenditure_items_all
4518: where transaction_source in ('OLD','GOLD')
4519: and orig_transaction_reference in
4520: (select to_char(summary_line_id)
4521: from psp_summary_lines

Line 4558: from pa_expenditure_items_all ITEMS

4554: from psp_payroll_controls PPC
4555: where PPC.batch_name=l_batch_name
4556: and PPC.source_type='A')))
4557: and 0 = (select count(*)
4558: from pa_expenditure_items_all ITEMS
4559: where ITEMS.expenditure_id = EXP.expenditure_id);
4560:
4561: /*****************************************************************************
4562: Commenting the following for the Bug 2290051