DBA Data[Home] [Help]

APPS.PA_FP_WEBADI_PKG dependencies on PA_SPREAD_CURVES_TL

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

Line 2584: pa_spread_curves_tl t

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

Line 11883: pa_spread_curves_tl psc,

11879: pa_proj_elements pe,
11880: pa_proj_element_versions pev,
11881: pa_resource_list_members prlm,
11882: pa_lookups uom,
11883: pa_spread_curves_tl psc,
11884: cst_cost_types cct,
11885: pa_lookups etc,
11886: pa_projects_all ppa
11887: WHERE pra.budget_version_id = c_budget_version_id