DBA Data[Home] [Help]

APPS.IGS_AD_TI_COMP dependencies on IGS_AD_CODE_CLASSES

Line 72: FROM igs_ad_code_classes

68: FROM igs_ad_app_req
69: WHERE admission_appl_number = p_admission_appl_number
70: AND person_id = p_person_id
71: AND applicant_fee_type IN (SELECT code_id
72: FROM igs_ad_code_classes
73: WHERE class = 'SYS_FEE_TYPE'
74: AND system_status IN ('ENROLL_DEPOSIT')
75: AND CLASS_TYPE_CODE='ADM_CODE_CLASSES')
76: AND applicant_fee_status IN (SELECT code_id

Line 77: FROM igs_ad_code_classes

73: WHERE class = 'SYS_FEE_TYPE'
74: AND system_status IN ('ENROLL_DEPOSIT')
75: AND CLASS_TYPE_CODE='ADM_CODE_CLASSES')
76: AND applicant_fee_status IN (SELECT code_id
77: FROM igs_ad_code_classes
78: WHERE class = 'SYS_FEE_STATUS'
79: AND system_status IN ('PAID','WAIVED')
80: AND CLASS_TYPE_CODE='ADM_CODE_CLASSES');
81: