APPS.PN_RECOVERY_EXTRACT_PKG dependencies on PN_REC_EXPCL_DTLLN_ALL

Line 2624: DELETE FROM pn_rec_expcl_dtlln_all

2620: DELETE FROM pn_rec_expcl_dtlacc_all
2621: WHERE expense_class_line_dtl_id = l_detail_delete_table(i);
2622:
2623: FORALL i IN 0 .. l_master_delete_table.COUNT - 1
2624: DELETE FROM pn_rec_expcl_dtlln_all
2625: WHERE expense_class_line_id = l_master_delete_table(i);
2626:
2627:
2628: pnp_debug_pkg.log(l_desc ||' (-)');

Line 2734: UPDATE pn_rec_expcl_dtlln_all

2730: l_info := ' updating header information ';
2731: pnp_debug_pkg.log(l_info);
2732:
2733: FORALL i IN 0 .. update_list.COUNT - 1
2734: UPDATE pn_rec_expcl_dtlln_all
2735: SET budgeted_amt = budgeted_list(i),
2736: expense_amt = expense_list(i),
2737: recoverable_amt = recoverable_list(i),
2738: computed_recoverable_amt = computed_recoverable_list(i) *

Line 2750: DELETE pn_rec_expcl_dtlln_all

2746: l_info := ' deleting unused header lines';
2747: pnp_debug_pkg.log(l_info);
2748:
2749: FORALL i IN 0 .. delete_list.COUNT - 1
2750: DELETE pn_rec_expcl_dtlln_all
2751: WHERE expense_class_line_id = delete_list(i);
2752:
2753: pnp_debug_pkg.log(l_desc ||' (-)');
2754:

Line 3283: pn_rec_expcl_dtlln_all class_line,

3279: class_line_dtl.expense_account_id exp_acct,
3280: class_line_dtl.expense_class_line_dtl_id dtl_id,
3281: class_line_dtl.expense_class_line_id mst_id
3282: FROM pn_rec_expcl_dtl_all summary,
3283: pn_rec_expcl_dtlln_all class_line,
3284: pn_rec_expcl_dtlacc_all class_line_dtl,
3285: pn_rec_expcl_all class,
3286: pn_rec_exp_line_all lines
3287: WHERE class_line.expense_class_line_id = class_line_dtl.expense_class_line_id

Line 3321: FROM pn_rec_expcl_dtlln_all class_line,

3317: class_line.recovery_space_std_code rec_space_std,
3318: class_line.recovery_type_code rec_type_code,
3319: class_line_dtl.expense_type_code exp_type,
3320: class_line_dtl.expense_account_id exp_acct
3321: FROM pn_rec_expcl_dtlln_all class_line,
3322: pn_rec_expcl_dtlacc_all class_line_dtl
3323: WHERE class_line.expense_class_line_id = class_line_dtl.expense_class_line_id
3324: AND class_line.expense_class_dtl_id = p_prior_cls_dtl_id;
3325: