APPS.PN_RECOVERY_EXTRACT_PKG dependencies on PN_REC_EXPCL_DTL_ALL

Line 3282: FROM pn_rec_expcl_dtl_all summary,

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

Line 3296: FROM pn_rec_expcl_dtl_all summary,

3292: AND lines.expense_line_id = p_expense_line_id;
3293:
3294: CURSOR get_prior_cls_dtl_id IS
3295: SELECT summary.expense_class_dtl_id
3296: FROM pn_rec_expcl_dtl_all summary,
3297: pn_rec_expcl_all class,
3298: pn_rec_exp_line_all line_hdr,
3299: (SELECT to_date, as_of_date FROM pn_rec_exp_line_all
3300: WHERE expense_line_id = p_expense_line_id) ref_line_hdr

Line 3334: FROM pn_rec_expcl_dtl_all dtl,

3330: dtl.default_area_class_id,
3331: dtl.cls_line_portion_pct,
3332: dtl.cls_line_fee_before_contr,
3333: dtl.cls_line_fee_after_contr
3334: FROM pn_rec_expcl_dtl_all dtl,
3335: pn_rec_expcl_all setup
3336: WHERE dtl.expense_line_id = p_expense_line_id
3337: AND setup.expense_class_id = p_expense_class_id
3338: AND setup.expense_class_id = dtl.expense_class_id;