APPS.PSP_SUM_ADJ dependencies on PA_EXPENDITURES_ALL

Line 3868: from pa_expenditures_all

3864: get_completion_rec get_completion%ROWTYPE;
3865: --- Bug 2133056, purge the PA Side items, if PA post import user extension failed.
3866: CURSOR group_name_cur IS
3867: select expenditure_group
3868: from pa_expenditures_all
3869: where expenditure_id in
3870: (select expenditure_id
3871: from pa_transaction_interface_all
3872: where transaction_source in ('OLD', 'GOLD') and

Line 3959: from pa_expenditures_all

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
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:

Line 3968: from pa_expenditures_all

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
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:

Line 3973: delete 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:
3976: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' deleted from pa_expenditures_all count: '||sql%rowcount);
3977:

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

3972:
3973: delete pa_expenditures_all
3974: where expenditure_group = l_exp_group_name;
3975:
3976: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' deleted from pa_expenditures_all count: '||sql%rowcount);
3977:
3978: delete pa_expenditure_Groups_all
3979: where expenditure_group = l_exp_group_name;
3980: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' deleted from pa_expenditure_Groups_all count: '||sql%rowcount);

Line 4471: from pa_expenditures_all

4467:
4468: -- Tuned following stmt 2133056
4469: CURSOR group_name_cur IS
4470: select expenditure_group
4471: from pa_expenditures_all
4472: where expenditure_id in
4473: (select expenditure_id
4474: from pa_transaction_interface_all
4475: where transaction_source in ('OLD', 'GOLD') and

Line 4544: delete pa_expenditures_all EXP

4540: and source_type = 'A'));
4541: ********************************************************************************/
4542:
4543: -- Bug 2133056.. Corrected not to delete non-orphan expenditures
4544: delete pa_expenditures_all EXP
4545: where EXP.expenditure_id in
4546: (select XFACE.expenditure_id
4547: from pa_transaction_interface_all XFACE
4548: where XFACE.transaction_source in('OLD','GOLD')

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

4574: ******************************************************************************/
4575: -- 1662816 start
4576: delete pa_expenditure_groups_all
4577: where transaction_source in('OLD','GOLD')
4578: and (0) = (select count(*) from pa_expenditures_all where expenditure_group=l_exp_group_name)
4579: and expenditure_group = l_exp_group_name;
4580:
4581:
4582: end if;