APPS.PN_REC_CALC_PKG dependencies on PN_REC_EXPCL_ALL

Line 2940: l_expense_class_id pn_rec_expcl_all.expense_class_id%TYPE;

2936:
2937: l_line_expenses pn_rec_expcl_dtlln_all.computed_recoverable_amt%TYPE;
2938: l_fee_before pn_rec_expcl_dtlln_all.cls_line_fee_before_contr_ovr%TYPE;
2939: l_fee_after pn_rec_expcl_dtlln_all.cls_line_fee_after_contr_ovr%TYPE;
2940: l_expense_class_id pn_rec_expcl_all.expense_class_id%TYPE;
2941: l_expense_type_count Number := 0;
2942:
2943: BEGIN
2944:

Line 2953: FROM pn_rec_expcl_all rec_exp_class

2949: nvl(exp_detail_line.cls_line_fee_before_contr_ovr,0),
2950: nvl(exp_detail_hdr.cls_line_fee_after_contr,0),
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

Line 2986: FROM pn_rec_expcl_all rec_exp_class

2982: SELECT distinct nvl(exp_detail_acc.computed_recoverable_amt,0),
2983: nvl(exp_detail_acc.cls_line_dtl_fee_bf_contr_ovr,0),
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

Line 3110: FROM pn_rec_expcl_all rec_exp_class

3106: )/100)
3107: ,0)
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

Line 5184: FROM pn_rec_expcl_all rec_exp_class

5180: p_calc_period_as_of_date date,
5181: p_rec_agr_line_id number) is
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