APPS.PN_RECOVERY_EXTRACT_PKG dependencies on PN_REC_EXPCL_DTL_ALL

Line 3294: FROM pn_rec_expcl_dtl_all summary,

3290: class_line_dtl.expense_type_code exp_type,
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

Line 3308: FROM pn_rec_expcl_dtl_all summary,

3304: AND lines.expense_line_id = p_expense_line_id;
3305:
3306: CURSOR get_prior_cls_dtl_id IS
3307: SELECT summary.expense_class_dtl_id
3308: FROM pn_rec_expcl_dtl_all summary,
3309: pn_rec_expcl_all class,
3310: pn_rec_exp_line_all line_hdr,
3311: (SELECT to_date, as_of_date FROM pn_rec_exp_line_all
3312: WHERE expense_line_id = p_expense_line_id) ref_line_hdr

Line 3346: FROM pn_rec_expcl_dtl_all dtl,

3342: dtl.default_area_class_id,
3343: dtl.cls_line_portion_pct,
3344: dtl.cls_line_fee_before_contr,
3345: dtl.cls_line_fee_after_contr
3346: FROM pn_rec_expcl_dtl_all dtl,
3347: pn_rec_expcl_all setup
3348: WHERE dtl.expense_line_id = p_expense_line_id
3349: AND setup.expense_class_id = p_expense_class_id
3350: AND setup.expense_class_id = dtl.expense_class_id;