DBA Data[Home] [Help]

APPS.PSP_SUM_ADJ dependencies on PA_EXPENDITURE_GROUPS_ALL

Line 3978: delete pa_expenditure_Groups_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);
3981:
3982: end if;

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

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);
3981:
3982: end if;
3983:
3984: if (l_txn_source = 'GOLD') then

Line 4576: delete pa_expenditure_groups_all

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