[Home] [Help]
2951: rec_exp_class.expense_class_id
2952: INTO l_line_expenses, l_fee_before, l_fee_after, l_expense_class_id
2953: FROM pn_rec_expcl_all rec_exp_class
2954: ,pn_rec_agr_linexp_all lineexp
2955: ,pn_rec_expcl_dtl_all exp_detail_hdr
2956: ,pn_rec_exp_line_all exp_extract_hdr
2957: ,pn_rec_expcl_dtlln_all exp_detail_line
2958: WHERE exp_detail_hdr.expense_class_dtl_id = exp_detail_line.expense_class_dtl_id
2959: AND exp_detail_line.cust_account_id = p_customer_id
2984: nvl(exp_detail_hdr.cls_line_fee_after_contr,0)
2985: INTO l_line_expenses, l_fee_before, l_fee_after
2986: FROM pn_rec_expcl_all rec_exp_class
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
3108: ) ,0)
3109: INTO l_budget_expenses
3110: FROM pn_rec_expcl_all rec_exp_class
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
5182: SELECT
5183: exp_detail_hdr.expense_class_dtl_id as expense_class_dtl_id
5184: FROM pn_rec_expcl_all rec_exp_class
5185: ,pn_rec_agr_linexp_all lineexp
5186: ,pn_rec_expcl_dtl_all exp_detail_hdr
5187: ,pn_rec_exp_line_all exp_extract_hdr
5188: ,pn_rec_expcl_dtlln_all exp_detail_line
5189: WHERE exp_detail_hdr.expense_class_dtl_id = exp_detail_line.expense_class_dtl_id
5190: AND exp_detail_line.cust_account_id = p_customer_id
5293: l_end_date,
5294: l_as_of_date,
5295: l_rec_agr_line_id )
5296: LOOP
5297: update pn_rec_expcl_dtl_all
5298: set status = 'LOCKED',
5299: last_update_date = sysdate,
5300: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
5301: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)