APPS.PN_REC_CALC_PKG dependencies on PN_REC_EXPCL_DTL_ALL

Line 2915: ,pn_rec_expcl_dtl_all exp_detail_hdr

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

Line 3027: ,pn_rec_expcl_dtl_all exp_detail_hdr

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

Line 5101: ,pn_rec_expcl_dtl_all exp_detail_hdr

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

Line 5212: update pn_rec_expcl_dtl_all

5208: l_end_date,
5209: l_as_of_date,
5210: l_rec_agr_line_id )
5211: LOOP
5212: update pn_rec_expcl_dtl_all
5213: set status = 'LOCKED',
5214: last_update_date = sysdate,
5215: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
5216: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)