APPS.PN_RECOVERY_EXTRACT_PKG dependencies on PN_REC_EXPCL_ALL

Line 2804: FROM pn_rec_expcl_all

2800:
2801: CURSOR get_expcl_by_prop (p_propid pn_rec_exp_line.property_id%TYPE,
2802: p_currency_code pn_rec_exp_line.currency_code%TYPE) IS
2803: SELECT expense_class_id
2804: FROM pn_rec_expcl_all
2805: WHERE property_id = p_propid
2806: AND location_id IS NULL
2807: AND currency_code = p_currency_code;
2808:

Line 2812: FROM pn_rec_expcl_all

2808:
2809: CURSOR get_expcl_by_locn (p_locnid pn_rec_exp_line.location_id%TYPE,
2810: p_currency_code pn_rec_exp_line.currency_code%TYPE) IS
2811: SELECT expense_class_id
2812: FROM pn_rec_expcl_all
2813: WHERE location_id = p_locnid
2814: AND currency_code = p_currency_code;
2815:
2816: CURSOR get_locn_prop_id IS

Line 3198: (SELECT currency_code FROM pn_rec_expcl_all

3194: SELECT 1
3195: FROM pn_rec_exp_line_all
3196: WHERE expense_line_id = p_expense_line_id
3197: AND currency_code NOT IN
3198: (SELECT currency_code FROM pn_rec_expcl_all
3199: WHERE expense_class_id = p_expense_class_id);
3200:
3201: CURSOR get_exp_class_info IS
3202: SELECT class.expense_class_id,

Line 3215: FROM pn_rec_expcl_all class,

3211: class.class_fee_after_contr,
3212: class_inclusion.cls_incl_fee_before_contr,
3213: class_inclusion.recovery_type_code,
3214: class_inclusion.recovery_space_std_code
3215: FROM pn_rec_expcl_all class,
3216: pn_rec_expcl_type_all class_type,
3217: pn_rec_expcl_inc_all class_inclusion
3218: WHERE class.expense_class_id = class_type.expense_class_id
3219: AND class_type.expense_class_type_id = class_inclusion.expense_class_type_id

Line 3285: pn_rec_expcl_all class,

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
3288: AND class_line.expense_class_dtl_id = summary.expense_class_dtl_id
3289: AND summary.expense_class_id = class.expense_class_id

Line 3297: pn_rec_expcl_all class,

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
3301: WHERE summary.expense_class_id = class.expense_class_id

Line 3335: pn_rec_expcl_all setup

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;
3339: