APPS.PN_RECOVERY_EXTRACT_PKG dependencies on PN_REC_EXPCL_DTLLN_ALL

Line 2636: DELETE FROM pn_rec_expcl_dtlln_all

2632: DELETE FROM pn_rec_expcl_dtlacc_all
2633: WHERE expense_class_line_dtl_id = l_detail_delete_table(i);
2634:
2635: FORALL i IN 0 .. l_master_delete_table.COUNT - 1
2636: DELETE FROM pn_rec_expcl_dtlln_all
2637: WHERE expense_class_line_id = l_master_delete_table(i);
2638:
2639:
2640: pnp_debug_pkg.log(l_desc ||' (-)');

Line 2746: UPDATE pn_rec_expcl_dtlln_all

2742: l_info := ' updating header information ';
2743: pnp_debug_pkg.log(l_info);
2744:
2745: FORALL i IN 0 .. update_list.COUNT - 1
2746: UPDATE pn_rec_expcl_dtlln_all
2747: SET budgeted_amt = budgeted_list(i),
2748: expense_amt = expense_list(i),
2749: recoverable_amt = recoverable_list(i),
2750: computed_recoverable_amt = computed_recoverable_list(i) *

Line 2762: DELETE pn_rec_expcl_dtlln_all

2758: l_info := ' deleting unused header lines';
2759: pnp_debug_pkg.log(l_info);
2760:
2761: FORALL i IN 0 .. delete_list.COUNT - 1
2762: DELETE pn_rec_expcl_dtlln_all
2763: WHERE expense_class_line_id = delete_list(i);
2764:
2765: pnp_debug_pkg.log(l_desc ||' (-)');
2766:

Line 3295: pn_rec_expcl_dtlln_all class_line,

3291: class_line_dtl.expense_account_id exp_acct,
3292: class_line_dtl.expense_class_line_dtl_id dtl_id,
3293: class_line_dtl.expense_class_line_id mst_id
3294: FROM pn_rec_expcl_dtl_all summary,
3295: pn_rec_expcl_dtlln_all class_line,
3296: pn_rec_expcl_dtlacc_all class_line_dtl,
3297: pn_rec_expcl_all class,
3298: pn_rec_exp_line_all lines
3299: WHERE class_line.expense_class_line_id = class_line_dtl.expense_class_line_id

Line 3333: FROM pn_rec_expcl_dtlln_all class_line,

3329: class_line.recovery_space_std_code rec_space_std,
3330: class_line.recovery_type_code rec_type_code,
3331: class_line_dtl.expense_type_code exp_type,
3332: class_line_dtl.expense_account_id exp_acct
3333: FROM pn_rec_expcl_dtlln_all class_line,
3334: pn_rec_expcl_dtlacc_all class_line_dtl
3335: WHERE class_line.expense_class_line_id = class_line_dtl.expense_class_line_id
3336: AND class_line.expense_class_dtl_id = p_prior_cls_dtl_id;
3337: