APPS.IGS_AD_SS_APPL_FEE_PKG dependencies on IGS_AD_CODE_CLASSES

Line 633: FROM igs_ad_code_classes

629: apl.admission_appl_number = p_admission_appl_number AND
630: apl.person_id = req.person_id AND
631: apl.admission_appl_number= req.admission_appl_number AND
632: EXISTS (SELECT 'x'
633: FROM igs_ad_code_classes
634: WHERE class = 'SYS_FEE_TYPE'
635: AND system_status = 'APPL_FEE'
636: AND applicant_fee_type = code_id
637: AND CLASS_TYPE_CODE = 'ADM_CODE_CLASSES')

Line 754: FROM igs_ad_code_classes

750:
751: --CURSOR which retrieves the default System Status for the given System Fee Method
752: CURSOR def_pay_method_cur IS
753: SELECT code_id
754: FROM igs_ad_code_classes
755: WHERE system_status = p_sys_fee_method
756: AND system_default = 'Y'
757: AND CLASS_TYPE_CODE='ADM_CODE_CLASSES';
758: -- removed the check whether there is already a transaction with the same Fee Type

Line 762: FROM igs_ad_code_classes

758: -- removed the check whether there is already a transaction with the same Fee Type
759: --CURSOR which retrieves the default System Status for the given System Fee Status
760: CURSOR def_fee_status_cur IS
761: SELECT code_id
762: FROM igs_ad_code_classes
763: WHERE system_status = p_sys_fee_status
764: AND system_default = 'Y'
765: AND CLASS_TYPE_CODE='ADM_CODE_CLASSES';
766:

Line 770: FROM igs_ad_code_classes

766:
767: --CURSOR which retrieves the default System Status for the given System Fee Type
768: CURSOR def_fee_types_cur IS
769: SELECT code_id
770: FROM igs_ad_code_classes
771: WHERE system_status = p_sys_fee_type
772: AND system_default = 'Y'
773: AND CLASS_TYPE_CODE='ADM_CODE_CLASSES';
774:

Line 776: l_default_pay_method igs_ad_code_classes.code_id%TYPE;

772: AND system_default = 'Y'
773: AND CLASS_TYPE_CODE='ADM_CODE_CLASSES';
774:
775:
776: l_default_pay_method igs_ad_code_classes.code_id%TYPE;
777: l_default_fee_status igs_ad_code_classes.code_id%TYPE;
778: l_default_fee_type igs_ad_code_classes.code_id%TYPE;
779: l_rowid VARCHAR2(100);
780: l_app_req_id NUMBER(15);

Line 777: l_default_fee_status igs_ad_code_classes.code_id%TYPE;

773: AND CLASS_TYPE_CODE='ADM_CODE_CLASSES';
774:
775:
776: l_default_pay_method igs_ad_code_classes.code_id%TYPE;
777: l_default_fee_status igs_ad_code_classes.code_id%TYPE;
778: l_default_fee_type igs_ad_code_classes.code_id%TYPE;
779: l_rowid VARCHAR2(100);
780: l_app_req_id NUMBER(15);
781: lv_person_id igs_ad_appl.person_id%TYPE;

Line 778: l_default_fee_type igs_ad_code_classes.code_id%TYPE;

774:
775:
776: l_default_pay_method igs_ad_code_classes.code_id%TYPE;
777: l_default_fee_status igs_ad_code_classes.code_id%TYPE;
778: l_default_fee_type igs_ad_code_classes.code_id%TYPE;
779: l_rowid VARCHAR2(100);
780: l_app_req_id NUMBER(15);
781: lv_person_id igs_ad_appl.person_id%TYPE;
782: lv_dup_person VARCHAR2(10);