DBA Data[Home] [Help]

APPS.IGS_PS_VAL_CRV dependencies on IGS_PS_ENT_PT_REF_CD

Line 402: FROM IGS_PS_ENT_PT_REF_CD

398: version_number = p_version_number AND
399: delete_flag = 'N';
400: CURSOR c_get_dist_reference_cd_type IS
401: SELECT DISTINCT reference_cd_type
402: FROM IGS_PS_ENT_PT_REF_CD
403: WHERE course_cd = p_course_cd AND
404: version_number = p_version_number;
405: CURSOR c_get_s_course_status IS
406: SELECT s_course_status

Line 636: -- Validate IGS_PS_ENT_PT_REF_CD record(s) if

632: END LOOP;
633: IF (v_terminate = TRUE) THEN
634: RETURN FALSE;
635: END IF;
636: -- Validate IGS_PS_ENT_PT_REF_CD record(s) if
637: -- it exists and that IGS_GE_REF_CD_TYPE is not closed.
638: -- Validate IGS_PS_OFR_INST record(s) if
639: -- it exists and the IGS_CA_INST.IGS_CA_STAT is ACTIVE.
640: -- Only perform these if course_offering_records exist.