DBA Data[Home] [Help]

APPS.PA_ALLOC_RUN dependencies on PA_EXPENDITURES

Line 9317: from pa_expenditures

9313: l_cnt_ex number:=0; /* added for bug 6243121 */
9314:
9315: Cursor C_expenditure is
9316: Select expenditure_id
9317: from pa_expenditures
9318: where expenditure_group in (v_tgt_exp_group,v_off_exp_group) ;
9319: --Get the the rule name for capitalized interest
9320: Cursor C_cint_rule_name IS
9321: SELECT meaning

Line 9630: delete from pa_expenditures

9626: If v_import_failed ='Y' then
9627: For exp_rec in C_expenditure LOOP
9628: delete from pa_expenditure_items
9629: where expenditure_id = exp_rec.expenditure_id ;
9630: delete from pa_expenditures
9631: where expenditure_id = exp_rec.expenditure_id ;
9632: END LOOP ;
9633: Delete from pa_expenditure_groups
9634: where expenditure_group in ( v_tgt_exp_group, v_off_exp_group) ;