APPS.PSP_SUM_ADJ dependencies on PA_EXPENDITURE_GROUPS_ALL

Line 3600: delete pa_expenditure_Groups_all

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;
3602: end if;
3603:
3604: if (l_txn_source = 'GOLD') then

Line 4145: delete pa_expenditure_groups_all

4141: where batch_name = l_batch_name
4142: and source_type = 'A'));
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: