APPS.PA_FP_WEBADI_PKG dependencies on PA_SPREAD_CURVES_B

Line 1854: l_fixed_spread_curve_id pa_spread_curves_b.spread_curve_id%TYPE;

1850: l_err_rlm_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1851: l_err_txn_curr_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1852: l_err_amt_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1853:
1854: l_fixed_spread_curve_id pa_spread_curves_b.spread_curve_id%TYPE;
1855: l_fixed_spread_curve_name pa_spread_curves_tl.name%TYPE;
1856: l_spread_curve_id pa_spread_curves_b.spread_curve_id%TYPE;
1857: l_sp_fixed_date pa_resource_assignments.sp_fixed_date%TYPE;
1858: l_not_null_period_cnt NUMBER;

Line 1856: l_spread_curve_id pa_spread_curves_b.spread_curve_id%TYPE;

1852: l_err_amt_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1853:
1854: l_fixed_spread_curve_id pa_spread_curves_b.spread_curve_id%TYPE;
1855: l_fixed_spread_curve_name pa_spread_curves_tl.name%TYPE;
1856: l_spread_curve_id pa_spread_curves_b.spread_curve_id%TYPE;
1857: l_sp_fixed_date pa_resource_assignments.sp_fixed_date%TYPE;
1858: l_not_null_period_cnt NUMBER;
1859: l_fix_sc_amt_pd_curr_index NUMBER; /* to get the period index for which amount is present if the spread curve */
1860: l_fix_sc_amt_pd_next_index NUMBER; /* associated with the resource is fixed date type */

Line 2631: FROM pa_spread_curves_b a,

2627: SELECT t.name,
2628: a.spread_curve_id
2629: INTO l_fixed_spread_curve_name,
2630: l_fixed_spread_curve_id
2631: FROM pa_spread_curves_b a,
2632: pa_spread_curves_tl t
2633: WHERE a.spread_curve_id = t.spread_curve_id
2634: AND a.spread_curve_code = 'FIXED_DATE'
2635: AND t.language = userenv('LANG');