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.

[Home] [Help]

APPS.PN_REC_CALC_PKG dependencies on PN_REC_AGR_LINEXP_ALL

Line 2914: ,pn_rec_agr_linexp_all lineexp

2910: nvl(exp_detail_line.cls_line_fee_before_contr_ovr,0),
2911: nvl(exp_detail_hdr.cls_line_fee_after_contr,0)
2912: INTO l_line_expenses, l_fee_before, l_fee_after
2913: FROM pn_rec_expcl_all rec_exp_class
2914: ,pn_rec_agr_linexp_all lineexp
2915: ,pn_rec_expcl_dtl_all exp_detail_hdr
2916: ,pn_rec_exp_line_all exp_extract_hdr
2917: ,pn_rec_expcl_dtlln_all exp_detail_line
2918: WHERE exp_detail_hdr.expense_class_dtl_id = exp_detail_line.expense_class_dtl_id

Line 3026: ,pn_rec_agr_linexp_all lineexp

3022: ,0)
3023: ) ,0)
3024: INTO l_budget_expenses
3025: FROM pn_rec_expcl_all rec_exp_class
3026: ,pn_rec_agr_linexp_all lineexp
3027: ,pn_rec_expcl_dtl_all exp_detail_hdr
3028: ,pn_rec_exp_line_all exp_extract_hdr
3029: ,pn_rec_expcl_dtlln_all exp_detail_line
3030: ,pn_rec_expcl_dtlacc_all expcl_lndtl_alloc

Line 5100: ,pn_rec_agr_linexp_all lineexp

5096: p_rec_agr_line_id number) is
5097: SELECT
5098: exp_detail_hdr.expense_class_dtl_id as expense_class_dtl_id
5099: FROM pn_rec_expcl_all rec_exp_class
5100: ,pn_rec_agr_linexp_all lineexp
5101: ,pn_rec_expcl_dtl_all exp_detail_hdr
5102: ,pn_rec_exp_line_all exp_extract_hdr
5103: ,pn_rec_expcl_dtlln_all exp_detail_line
5104: WHERE exp_detail_hdr.expense_class_dtl_id = exp_detail_line.expense_class_dtl_id