APPS.PSP_SUM_ADJ dependencies on PA_EXPENDITURES_ALL

Line 3509: from pa_expenditures_all

3505: get_completion_rec get_completion%ROWTYPE;
3506: --- Bug 2133056, purge the PA Side items, if PA post import user extension failed.
3507: CURSOR group_name_cur IS
3508: select expenditure_group
3509: from pa_expenditures_all
3510: where expenditure_id in
3511: (select expenditure_id
3512: from pa_transaction_interface_all
3513: where transaction_source in ('OLD', 'GOLD') and

Line 3587: from pa_expenditures_all

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
3588: where expenditure_group = l_exp_group_name));
3589:
3590: delete pa_expenditure_items_all
3591: where transaction_source in ('OLD','GOLD')

Line 3594: from pa_expenditures_all

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
3595: where expenditure_group = l_exp_group_name);
3596:
3597: delete pa_expenditures_all
3598: where expenditure_group = l_exp_group_name;

Line 3597: delete pa_expenditures_all

3593: (select expenditure_id
3594: from pa_expenditures_all
3595: where expenditure_group = l_exp_group_name);
3596:
3597: delete pa_expenditures_all
3598: where expenditure_group = l_exp_group_name;
3599:
3600: delete pa_expenditure_Groups_all
3601: where expenditure_group = l_exp_group_name;

Line 4040: from pa_expenditures_all

4036:
4037: -- Tuned following stmt 2133056
4038: CURSOR group_name_cur IS
4039: select expenditure_group
4040: from pa_expenditures_all
4041: where expenditure_id in
4042: (select expenditure_id
4043: from pa_transaction_interface_all
4044: where transaction_source in ('OLD', 'GOLD') and

Line 4113: delete pa_expenditures_all EXP

4109: and source_type = 'A'));
4110: ********************************************************************************/
4111:
4112: -- Bug 2133056.. Corrected not to delete non-orphan expenditures
4113: delete pa_expenditures_all EXP
4114: where EXP.expenditure_id in
4115: (select XFACE.expenditure_id
4116: from pa_transaction_interface_all XFACE
4117: where XFACE.transaction_source in('OLD','GOLD')

Line 4147: and (0) = (select count(*) from pa_expenditures_all where expenditure_group=l_exp_group_name)

4143: ******************************************************************************/
4144: -- 1662816 start
4145: delete pa_expenditure_groups_all
4146: where transaction_source in('OLD','GOLD')
4147: and (0) = (select count(*) from pa_expenditures_all where expenditure_group=l_exp_group_name)
4148: and expenditure_group = l_exp_group_name;
4149:
4150:
4151: end if;