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_REC_CALC_PKG dependencies on PN_REC_EXPCL_DTLACC_ALL

Line 2920: | will be derived from pn_rec_expcl_dtlacc_all table

2916: | MODIFICATION HISTORY
2917: |
2918: | 19-MAY-2003 Daniel Thota o Created
2919: | 24-SEP-2010 asahoo bug#9269643 If a Expense Class has more than one Expense Type expense amount will be
2920: | will be derived from pn_rec_expcl_dtlacc_all table
2921: +===========================================================================*/
2922: PROCEDURE get_line_expenses (
2923: p_rec_agr_line_id IN NUMBER
2924: ,p_customer_id IN NUMBER

Line 2991: ,pn_rec_expcl_dtlacc_all exp_detail_acc

2987: ,pn_rec_agr_linexp_all lineexp
2988: ,pn_rec_expcl_dtl_all exp_detail_hdr
2989: ,pn_rec_exp_line_all exp_extract_hdr
2990: ,pn_rec_expcl_dtlln_all exp_detail_line
2991: ,pn_rec_expcl_dtlacc_all exp_detail_acc
2992: ,pn_rec_agr_lines_all agrline
2993: WHERE exp_detail_hdr.expense_class_dtl_id = exp_detail_line.expense_class_dtl_id
2994: AND exp_detail_line.cust_account_id = p_customer_id
2995: AND exp_detail_line.lease_id = p_lease_id

Line 3115: ,pn_rec_expcl_dtlacc_all expcl_lndtl_alloc

3111: ,pn_rec_agr_linexp_all lineexp
3112: ,pn_rec_expcl_dtl_all exp_detail_hdr
3113: ,pn_rec_exp_line_all exp_extract_hdr
3114: ,pn_rec_expcl_dtlln_all exp_detail_line
3115: ,pn_rec_expcl_dtlacc_all expcl_lndtl_alloc
3116: WHERE exp_detail_hdr.expense_class_dtl_id = exp_detail_line.expense_class_dtl_id
3117: AND exp_detail_line.cust_account_id = p_customer_id
3118: AND exp_detail_line.lease_id = p_lease_id
3119: AND exp_detail_line.location_id = p_location_id