APPS.IGS_PS_VAL_CAL dependencies on IGS_PS_ANL_LOAD

Line 16: gv_effective_start_dt IGS_PS_ANL_LOAD.effective_start_dt%TYPE DEFAULT NULL;

12: p_version_number IN NUMBER ,
13: p_yr_num IN NUMBER ,
14: p_effective_start_dt IN DATE )
15: RETURN BOOLEAN AS
16: gv_effective_start_dt IGS_PS_ANL_LOAD.effective_start_dt%TYPE DEFAULT NULL;
17: gv_result CHAR;
18: CURSOR c_find_cal IS
19: SELECT MAX(effective_start_dt)
20: FROM IGS_PS_ANL_LOAD

Line 20: FROM IGS_PS_ANL_LOAD

16: gv_effective_start_dt IGS_PS_ANL_LOAD.effective_start_dt%TYPE DEFAULT NULL;
17: gv_result CHAR;
18: CURSOR c_find_cal IS
19: SELECT MAX(effective_start_dt)
20: FROM IGS_PS_ANL_LOAD
21: WHERE course_cd = p_course_cd AND
22: version_number = p_version_number AND
23: yr_num = p_yr_num AND
24: effective_start_dt < p_effective_start_dt;

Line 27: FROM IGS_PS_ANL_LOAD_U_LN

23: yr_num = p_yr_num AND
24: effective_start_dt < p_effective_start_dt;
25: CURSOR c_find_calul IS
26: SELECT 'x'
27: FROM IGS_PS_ANL_LOAD_U_LN
28: WHERE course_cd = p_course_cd AND
29: crv_version_number = p_version_number AND
30: yr_num = p_yr_num AND
31: effective_start_dt = gv_effective_start_dt;

Line 74: FROM IGS_PS_ANL_LOAD

70: RETURN BOOLEAN AS
71: v_check CHAR;
72: CURSOR c_get_course_annual_load_rec IS
73: SELECT 'x'
74: FROM IGS_PS_ANL_LOAD
75: WHERE course_cd = p_course_cd AND
76: version_number = p_version_number AND
77: yr_num = p_yr_num AND
78: effective_start_dt <> p_effective_start_dt AND