DBA Data[Home] [Help]

APPS.PA_ALLOC_RUN dependencies on PA_EXPENDITURES

Line 9422: from pa_expenditures

9418: l_cnt_ex number:=0; /* added for bug 6243121 */
9419:
9420: Cursor C_expenditure is
9421: Select expenditure_id
9422: from pa_expenditures
9423: where expenditure_group in (v_tgt_exp_group,v_off_exp_group) ;
9424: --Get the the rule name for capitalized interest
9425: Cursor C_cint_rule_name IS
9426: SELECT meaning

Line 9735: delete from pa_expenditures

9731: If v_import_failed ='Y' then
9732: For exp_rec in C_expenditure LOOP
9733: delete from pa_expenditure_items
9734: where expenditure_id = exp_rec.expenditure_id ;
9735: delete from pa_expenditures
9736: where expenditure_id = exp_rec.expenditure_id ;
9737: END LOOP ;
9738: Delete from pa_expenditure_groups
9739: where expenditure_group in ( v_tgt_exp_group, v_off_exp_group) ;