APPS.PA_TASK_ASSIGNMENTS_PUB dependencies on PA_SPREAD_CURVES_B

Line 3972: l_spread_curve_code pa_spread_curves_b.spread_curve_code%TYPE ;

3968: l_spread_curve_id NUMBER;
3969: l_spread_curve_exists VARCHAR2(1);
3970: l_fixed_date DATE;
3971: l_spread_curve_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3972: l_spread_curve_code pa_spread_curves_b.spread_curve_code%TYPE ;
3973: l_fixed_date_tbl system.pa_date_tbl_type :=system.pa_date_tbl_type();
3974: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE; --8429604
3975: --Bug#8646853 -Addition end
3976:

Line 4232: from pa_spread_curves_b a,

4228:
4229: --Added by rbanerje - Bug#8646853 -start
4230: Cursor C_Spread_Curve(p_spread_curve_name IN VARCHAR2) IS
4231: select a.spread_curve_id spread_curve_id
4232: from pa_spread_curves_b a,
4233: pa_spread_curves_tl t
4234: where t.name = p_spread_curve_name
4235: and a.spread_curve_id = t.spread_curve_id
4236: and t.language = userenv('LANG')

Line 4243: from pa_spread_curves_b

4239: c_spread_curve_rec C_Spread_Curve%ROWTYPE;
4240:
4241: Cursor C_Spread_Curve_Exists(p_spread_curve_id IN NUMBER) IS
4242: select 'X'
4243: from pa_spread_curves_b
4244: where spread_curve_id = p_spread_curve_id
4245: and sysdate BETWEEN effective_start_date AND nvl(effective_end_date,
4246: sysdate);
4247: c_spread_curve_exists_rec C_Spread_Curve_Exists%ROWTYPE;

Line 4251: from pa_spread_curves_b

4247: c_spread_curve_exists_rec C_Spread_Curve_Exists%ROWTYPE;
4248:
4249: Cursor C_Spread_Curve_Code(p_spread_curve_id IN NUMBER) IS
4250: select spread_curve_code
4251: from pa_spread_curves_b
4252: where spread_curve_id = p_spread_curve_id
4253: and sysdate BETWEEN effective_start_date AND nvl(effective_end_date,
4254: sysdate);
4255: c_spread_curve_code_rec C_Spread_Curve_Code%ROWTYPE;