APPS.IGS_AD_SS_APPL_FEE_PKG dependencies on IGS_AD_SS_APPL_TYP

Line 611: CURSOR get_account_details_cur(l_adm_application_type igs_ad_ss_appl_typ.admission_application_type%TYPE) IS

607: WHERE person_id = p_person_id AND
608: admission_appl_number = p_admission_appl_number;
609:
610: --Cursor to fetch the account details associated with the application_type into the OUT NOCOPY parameters
611: CURSOR get_account_details_cur(l_adm_application_type igs_ad_ss_appl_typ.admission_application_type%TYPE) IS
612: SELECT
613: gl_rev_acct_ccid,
614: gl_cash_acct_ccid,
615: rev_account_code,

Line 617: FROM igs_ad_ss_appl_typ

613: gl_rev_acct_ccid,
614: gl_cash_acct_ccid,
615: rev_account_code,
616: cash_account_code
617: FROM igs_ad_ss_appl_typ
618: WHERE admission_application_type = l_adm_application_type;
619:
620: -- Cursor to fetch the outstanding balance for the applicant --arvsrini
621: CURSOR c_appl_fee_amt IS

Line 649: l_application_type igs_ad_ss_appl_typ.admission_application_type%TYPE;

645: apl.person_id= p_person_id AND
646: apl.admission_appl_number = p_admission_appl_number;
647:
648:
649: l_application_type igs_ad_ss_appl_typ.admission_application_type%TYPE;
650:
651: BEGIN
652: OPEN get_appl_type_cur;
653: FETCH get_appl_type_cur INTO l_application_type;