DBA Data[Home] [Help]

APPS.PA_FP_WEBADI_PKG dependencies on PA_SPREAD_CURVES_TL

Line 1855: l_fixed_spread_curve_name pa_spread_curves_tl.name%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;
1859: l_fix_sc_amt_pd_curr_index NUMBER; /* to get the period index for which amount is present if the spread curve */

Line 2632: pa_spread_curves_tl t

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');
2636: EXCEPTION

Line 12116: pa_spread_curves_tl psc,

12112: pa_proj_elements pe,
12113: pa_proj_element_versions pev,
12114: pa_resource_list_members prlm,
12115: pa_lookups uom,
12116: pa_spread_curves_tl psc,
12117: cst_cost_types cct,
12118: pa_lookups etc,
12119: pa_projects_all ppa
12120: WHERE pra.budget_version_id = c_budget_version_id