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_EXP_LINE_ALL

Line 2916: ,pn_rec_exp_line_all exp_extract_hdr

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
2919: AND exp_detail_line.cust_account_id = p_customer_id
2920: AND exp_detail_line.lease_id = p_lease_id

Line 3028: ,pn_rec_exp_line_all exp_extract_hdr

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
3031: WHERE exp_detail_hdr.expense_class_dtl_id = exp_detail_line.expense_class_dtl_id
3032: AND exp_detail_line.cust_account_id = p_customer_id

Line 5102: ,pn_rec_exp_line_all exp_extract_hdr

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
5105: AND exp_detail_line.cust_account_id = p_customer_id
5106: AND exp_detail_line.lease_id = p_lease_id