DBA Data[Home] [Help]

APPS.PN_RECOVERY_EXTRACT_PKG dependencies on PN_REC_EXPCL_INC

Line 2262: p_use_fee_bf_contr pn_rec_expcl_inc.cls_incl_fee_before_contr%TYPE,

2258: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
2259: p_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
2260: p_cls_line_fee_af_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
2261: p_cls_line_fee_bf_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
2262: p_use_fee_bf_contr pn_rec_expcl_inc.cls_incl_fee_before_contr%TYPE,
2263: p_use_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
2264: p_use_prior_ovr BOOLEAN
2265: )
2266: IS

Line 2365: p_cls_line_shr_pct pn_rec_expcl_inc.cls_incl_share_pct%TYPE,

2361: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2362: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2363: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2364: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
2365: p_cls_line_shr_pct pn_rec_expcl_inc.cls_incl_share_pct%TYPE,
2366: p_cls_line_fee_bf_contr pn_rec_expcl_inc.cls_incl_fee_before_contr%TYPE,
2367: p_cls_line_shr_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
2368: p_cls_line_fee_bf_contr_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE
2369: )

Line 2366: p_cls_line_fee_bf_contr pn_rec_expcl_inc.cls_incl_fee_before_contr%TYPE,

2362: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2363: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2364: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
2365: p_cls_line_shr_pct pn_rec_expcl_inc.cls_incl_share_pct%TYPE,
2366: p_cls_line_fee_bf_contr pn_rec_expcl_inc.cls_incl_fee_before_contr%TYPE,
2367: p_cls_line_shr_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
2368: p_cls_line_fee_bf_contr_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE
2369: )
2370: IS

Line 3229: pn_rec_expcl_inc_all class_inclusion

3225: class_inclusion.recovery_type_code,
3226: class_inclusion.recovery_space_std_code
3227: FROM pn_rec_expcl_all class,
3228: pn_rec_expcl_type_all class_type,
3229: pn_rec_expcl_inc_all class_inclusion
3230: WHERE class.expense_class_id = class_type.expense_class_id
3231: AND class_type.expense_class_type_id = class_inclusion.expense_class_type_id
3232: AND class.expense_class_id = p_expense_class_id;
3233: