DBA Data[Home] [Help]

APPS.PN_RECOVERY_EXTRACT_PKG dependencies on PN_REC_EXPCL_INC

Line 2250: p_use_fee_bf_contr pn_rec_expcl_inc.cls_incl_fee_before_contr%TYPE,

2246: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
2247: p_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
2248: p_cls_line_fee_af_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
2249: p_cls_line_fee_bf_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
2250: p_use_fee_bf_contr pn_rec_expcl_inc.cls_incl_fee_before_contr%TYPE,
2251: p_use_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
2252: p_use_prior_ovr BOOLEAN
2253: )
2254: IS

Line 2353: p_cls_line_shr_pct pn_rec_expcl_inc.cls_incl_share_pct%TYPE,

2349: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2350: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2351: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2352: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
2353: p_cls_line_shr_pct pn_rec_expcl_inc.cls_incl_share_pct%TYPE,
2354: p_cls_line_fee_bf_contr pn_rec_expcl_inc.cls_incl_fee_before_contr%TYPE,
2355: p_cls_line_shr_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
2356: p_cls_line_fee_bf_contr_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE
2357: )

Line 2354: p_cls_line_fee_bf_contr pn_rec_expcl_inc.cls_incl_fee_before_contr%TYPE,

2350: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2351: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2352: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
2353: p_cls_line_shr_pct pn_rec_expcl_inc.cls_incl_share_pct%TYPE,
2354: p_cls_line_fee_bf_contr pn_rec_expcl_inc.cls_incl_fee_before_contr%TYPE,
2355: p_cls_line_shr_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
2356: p_cls_line_fee_bf_contr_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE
2357: )
2358: IS

Line 3217: pn_rec_expcl_inc_all class_inclusion

3213: class_inclusion.recovery_type_code,
3214: class_inclusion.recovery_space_std_code
3215: FROM pn_rec_expcl_all class,
3216: pn_rec_expcl_type_all class_type,
3217: pn_rec_expcl_inc_all class_inclusion
3218: WHERE class.expense_class_id = class_type.expense_class_id
3219: AND class_type.expense_class_type_id = class_inclusion.expense_class_type_id
3220: AND class.expense_class_id = p_expense_class_id;
3221: