APPS.PN_RECOVERY_EXTRACT_PKG dependencies on PN_REC_EXPCL_DTLACC_ALL

Line 2632: DELETE FROM pn_rec_expcl_dtlacc_all

2628: l_info := ' deleting unused data';
2629: pnp_debug_pkg.log(l_info);
2630:
2631: FORALL i IN 0 .. l_detail_delete_table.COUNT - 1
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

Line 2672: FROM pn_rec_expcl_dtlacc_all

2668: IS
2669: CURSOR get_affected_lines IS
2670: SELECT expense_class_line_dtl_id,
2671: expense_class_line_id
2672: FROM pn_rec_expcl_dtlacc_all
2673: WHERE expense_line_dtl_id = p_expense_line_dtl_id;
2674:
2675: CURSOR get_header_info (p_exp_cls_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE) IS
2676: SELECT sum(nvl(computed_recoverable_amt, 0)) computed_recoverable_amount,

Line 2682: FROM pn_rec_expcl_dtlacc_all

2678: sum(nvl(expense_amt, 0)) expense_amount,
2679: sum(nvl(budgeted_amt, 0)) budgeted_amount,
2680: min(decode(nvl(cls_line_dtl_share_pct_ovr, cls_line_dtl_share_pct), NULL, NULL, 100)) use_cls_line_share,
2681: min(decode(nvl(cls_line_dtl_fee_bf_contr_ovr, cls_line_dtl_fee_bf_contr), NULL, NULL, 0)) use_cls_line_fee
2682: FROM pn_rec_expcl_dtlacc_all
2683: WHERE expense_class_line_id = p_exp_cls_line_id;
2684:
2685: TYPE num_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2686: TYPE use_tbl IS TABLE OF BOOLEAN INDEX BY BINARY_INTEGER;

Line 2710: DELETE pn_rec_expcl_dtlacc_all

2706: l_info := ' processing affected lines ';
2707: pnp_debug_pkg.log(l_info);
2708:
2709: FOR class_line_dtl_rec IN get_affected_lines LOOP
2710: DELETE pn_rec_expcl_dtlacc_all
2711: WHERE expense_class_line_dtl_id = class_line_dtl_rec.expense_class_line_dtl_id;
2712: hdr_id_list(hdr_id_list.COUNT) := class_line_dtl_rec.expense_class_line_id;
2713: END LOOP;
2714:

Line 3296: pn_rec_expcl_dtlacc_all class_line_dtl,

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
3300: AND class_line.expense_class_dtl_id = summary.expense_class_dtl_id

Line 3334: pn_rec_expcl_dtlacc_all class_line_dtl

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:
3338: CURSOR is_reextract IS