APPS.PSP_SUM_ADJ dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 3583: from pa_expenditure_items_all

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
3584: where transaction_source = 'GOLD'
3585: and expenditure_id in
3586: (select expenditure_id
3587: from pa_expenditures_all

Line 3590: delete pa_expenditure_items_all

3586: (select expenditure_id
3587: from pa_expenditures_all
3588: where expenditure_group = l_exp_group_name));
3589:
3590: delete pa_expenditure_items_all
3591: where transaction_source in ('OLD','GOLD')
3592: and expenditure_id in
3593: (select expenditure_id
3594: from pa_expenditures_all

Line 4074: from pa_expenditure_items_all

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
4075: where transaction_source = 'GOLD'
4076: and orig_transaction_reference in
4077: (select to_char(summary_line_id)
4078: from psp_summary_lines

Line 4086: delete from pa_expenditure_items_all

4082: where batch_name = l_batch_name
4083: and source_type='A'))); ----- Added this delete for Bug 2133056
4084:
4085:
4086: delete from pa_expenditure_items_all
4087: where transaction_source in ('OLD','GOLD')
4088: and orig_transaction_reference in
4089: (select to_char(summary_line_id)
4090: from psp_summary_lines

Line 4127: from pa_expenditure_items_all ITEMS

4123: from psp_payroll_controls PPC
4124: where PPC.batch_name=l_batch_name
4125: and PPC.source_type='A')))
4126: and 0 = (select count(*)
4127: from pa_expenditure_items_all ITEMS
4128: where ITEMS.expenditure_id = EXP.expenditure_id);
4129:
4130: /*****************************************************************************
4131: Commenting the following for the Bug 2290051