APPS.IGS_AD_VAL_SCFT dependencies on IGS_PS_OFR_PAT

Line 81: -- exists and is offered within a IGS_PS_OFR_PAT that is in the

77: p_message_name OUT NOCOPY VARCHAR2 )
78: RETURN BOOLEAN AS
79: BEGIN -- admp_val_scft_cop
80: -- This module validates the IGS_PS_VER component of IGS_AD_SBM_PS_FNTRGT
81: -- exists and is offered within a IGS_PS_OFR_PAT that is in the
82: -- academic period of the submission period.
83: DECLARE
84: v_cop VARCHAR2(1);
85: CURSOR c_cop IS

Line 87: FROM IGS_PS_OFR_PAT cop,

83: DECLARE
84: v_cop VARCHAR2(1);
85: CURSOR c_cop IS
86: SELECT 'x'
87: FROM IGS_PS_OFR_PAT cop,
88: IGS_ST_GVTSEMLOAD_CA gslc,
89: IGS_CA_INST_REL cir
90: WHERE gslc.submission_yr = p_submission_yr AND
91: gslc.submission_number = p_submission_number AND

Line 263: -- at least one enrollable or offered IGS_PS_OFR_PAT for the academic

259: p_message_name OUT NOCOPY VARCHAR2 )
260: RETURN BOOLEAN AS
261: BEGIN -- admp_val_scft_dtl
262: -- This module validates the location_cd/attendance_mode/attendance_type are in
263: -- at least one enrollable or offered IGS_PS_OFR_PAT for the academic
264: -- period of the submission period.
265: DECLARE
266: v_cop VARCHAR2(1);
267: CURSOR c_cop IS

Line 269: FROM IGS_PS_OFR_PAT cop,

265: DECLARE
266: v_cop VARCHAR2(1);
267: CURSOR c_cop IS
268: SELECT 'x'
269: FROM IGS_PS_OFR_PAT cop,
270: IGS_ST_GVTSEMLOAD_CA gslc,
271: IGS_CA_INST_REL cir
272: WHERE gslc.submission_yr = p_submission_yr AND
273: gslc.submission_number = p_submission_number AND