DBA Data[Home] [Help]

APPS.PN_REC_CALC_PKG dependencies on PN_REC_EXPCL_ALL

Line 2913: FROM pn_rec_expcl_all rec_exp_class

2909: SELECT nvl(exp_detail_line.computed_recoverable_amt,0),
2910: nvl(exp_detail_line.cls_line_fee_before_contr_ovr,0),
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

Line 3025: FROM pn_rec_expcl_all rec_exp_class

3021: )/100)
3022: ,0)
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

Line 5099: FROM pn_rec_expcl_all rec_exp_class

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