APPS.PA_FP_WEBADI_PKG dependencies on PA_SPREAD_CURVES_B

Line 1852: l_fixed_spread_curve_id pa_spread_curves_b.spread_curve_id%TYPE;

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

Line 1854: l_spread_curve_id pa_spread_curves_b.spread_curve_id%TYPE;

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

Line 2583: FROM pa_spread_curves_b a,

2579: SELECT t.name,
2580: a.spread_curve_id
2581: INTO l_fixed_spread_curve_name,
2582: l_fixed_spread_curve_id
2583: FROM pa_spread_curves_b a,
2584: pa_spread_curves_tl t
2585: WHERE a.spread_curve_id = t.spread_curve_id
2586: AND a.spread_curve_code = 'FIXED_DATE'
2587: AND t.language = userenv('LANG');