APPS.IGS_AD_VAL_OSE dependencies on IGS_AD_OS_SEC_EDU_QF

Line 16: FROM IGS_AD_OS_SEC_EDU_QF oseq

12: DECLARE
13: v_oseq_closed_exist VARCHAR2(1);
14: CURSOR c_oseq_closed IS
15: SELECT 'x'
16: FROM IGS_AD_OS_SEC_EDU_QF oseq
17: WHERE oseq.os_scndry_edu_qualification=p_os_scndry_edu_qualification AND
18: closed_ind = 'Y';
19: BEGIN
20: -- Set the default message number

Line 53: -- Validate that the IGS_AD_OS_SEC_EDU_QF.country_cd is the same as the

49: p_country_cd IN VARCHAR2 ,
50: p_message_name OUT NOCOPY VARCHAR2 )
51: RETURN BOOLEAN AS
52: BEGIN -- admp_val_ose_qcntry
53: -- Validate that the IGS_AD_OS_SEC_EDU_QF.country_cd is the same as the
54: -- IGS_AD_OS_SEC_EDU.country_cd or that the
55: -- IGS_AD_OS_SEC_EDU_QF.country_cd is null.
56: DECLARE
57: v_country_cd IGS_AD_OS_SEC_EDU_QF.country_cd%TYPE;

Line 55: -- IGS_AD_OS_SEC_EDU_QF.country_cd is null.

51: RETURN BOOLEAN AS
52: BEGIN -- admp_val_ose_qcntry
53: -- Validate that the IGS_AD_OS_SEC_EDU_QF.country_cd is the same as the
54: -- IGS_AD_OS_SEC_EDU.country_cd or that the
55: -- IGS_AD_OS_SEC_EDU_QF.country_cd is null.
56: DECLARE
57: v_country_cd IGS_AD_OS_SEC_EDU_QF.country_cd%TYPE;
58: CURSOR c_oseq IS
59: SELECT COUNTRY_CD

Line 57: v_country_cd IGS_AD_OS_SEC_EDU_QF.country_cd%TYPE;

53: -- Validate that the IGS_AD_OS_SEC_EDU_QF.country_cd is the same as the
54: -- IGS_AD_OS_SEC_EDU.country_cd or that the
55: -- IGS_AD_OS_SEC_EDU_QF.country_cd is null.
56: DECLARE
57: v_country_cd IGS_AD_OS_SEC_EDU_QF.country_cd%TYPE;
58: CURSOR c_oseq IS
59: SELECT COUNTRY_CD
60: FROM IGS_AD_OS_SEC_EDU_QF
61: WHERE os_scndry_edu_qualification = p_os_scndry_edu_qualification;

Line 60: FROM IGS_AD_OS_SEC_EDU_QF

56: DECLARE
57: v_country_cd IGS_AD_OS_SEC_EDU_QF.country_cd%TYPE;
58: CURSOR c_oseq IS
59: SELECT COUNTRY_CD
60: FROM IGS_AD_OS_SEC_EDU_QF
61: WHERE os_scndry_edu_qualification = p_os_scndry_edu_qualification;
62: BEGIN
63: p_message_name := null;
64: IF (p_os_scndry_edu_qualification IS NOT NULL) THEN