eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_RECOVERY_EXTRACT_PKG dependencies on PN_REC_EXPCL_ALL

Line 2816: FROM pn_rec_expcl_all

2812:
2813: CURSOR get_expcl_by_prop (p_propid pn_rec_exp_line.property_id%TYPE,
2814: p_currency_code pn_rec_exp_line.currency_code%TYPE) IS
2815: SELECT expense_class_id
2816: FROM pn_rec_expcl_all
2817: WHERE property_id = p_propid
2818: AND location_id IS NULL
2819: AND currency_code = p_currency_code;
2820:

Line 2824: FROM pn_rec_expcl_all

2820:
2821: CURSOR get_expcl_by_locn (p_locnid pn_rec_exp_line.location_id%TYPE,
2822: p_currency_code pn_rec_exp_line.currency_code%TYPE) IS
2823: SELECT expense_class_id
2824: FROM pn_rec_expcl_all
2825: WHERE location_id = p_locnid
2826: AND currency_code = p_currency_code;
2827:
2828: CURSOR get_locn_prop_id IS

Line 3210: (SELECT currency_code FROM pn_rec_expcl_all

3206: SELECT 1
3207: FROM pn_rec_exp_line_all
3208: WHERE expense_line_id = p_expense_line_id
3209: AND currency_code NOT IN
3210: (SELECT currency_code FROM pn_rec_expcl_all
3211: WHERE expense_class_id = p_expense_class_id);
3212:
3213: CURSOR get_exp_class_info IS
3214: SELECT class.expense_class_id,

Line 3227: FROM pn_rec_expcl_all class,

3223: class.class_fee_after_contr,
3224: class_inclusion.cls_incl_fee_before_contr,
3225: class_inclusion.recovery_type_code,
3226: class_inclusion.recovery_space_std_code
3227: FROM pn_rec_expcl_all class,
3228: pn_rec_expcl_type_all class_type,
3229: pn_rec_expcl_inc_all class_inclusion
3230: WHERE class.expense_class_id = class_type.expense_class_id
3231: AND class_type.expense_class_type_id = class_inclusion.expense_class_type_id

Line 3297: pn_rec_expcl_all class,

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

Line 3309: pn_rec_expcl_all class,

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

Line 3347: pn_rec_expcl_all setup

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