APPS.IGS_AD_SS_GEN_001 dependencies on IGS_SS_AD_OTHINS_STG

Line 1092: FROM igs_ss_ad_othins_stg othinst,

1088: othinst.ss_adm_appl_id,
1089: othinst.institution_code,
1090: i.name,
1091: othinst.new_institution
1092: FROM igs_ss_ad_othins_stg othinst,
1093: igs_ss_adm_appl_stg appl,
1094: igs_or_institution i,
1095: igs_pe_hz_parties php
1096: WHERE othinst.ss_adm_appl_id = appl.ss_adm_appl_id

Line 1430: DELETE FROM igs_ss_ad_othins_stg

1426: WHERE ss_adm_appl_id = p_adm_appl_number;
1427: --added by nshee during build for Applicant-BOSS SS Bug 2622488
1428: -- needs to include in the
1429: -- delete stg table records section
1430: DELETE FROM igs_ss_ad_othins_stg
1431: WHERE ss_adm_appl_id = p_adm_appl_number;
1432: --dhan
1433: DELETE FROM igs_ss_app_pgm_stg
1434: WHERE person_id = p_person_id

Line 3940: CURSOR c_oth_inst(cp_Appl_Num IGS_SS_AD_OTHINS_STG.SS_ADM_APPL_ID%TYPE) IS

3936: AND admission_application_type = cp_ApplType
3937: AND Closed_flag <> 'Y');
3938:
3939: -- Other Institutions Applied- OTHER_INST
3940: CURSOR c_oth_inst(cp_Appl_Num IGS_SS_AD_OTHINS_STG.SS_ADM_APPL_ID%TYPE) IS
3941: SELECT 'x'
3942: FROM IGS_SS_AD_OTHINS_STG
3943: WHERE SS_ADM_APPL_ID = cp_Appl_Num;
3944:

Line 3942: FROM IGS_SS_AD_OTHINS_STG

3938:
3939: -- Other Institutions Applied- OTHER_INST
3940: CURSOR c_oth_inst(cp_Appl_Num IGS_SS_AD_OTHINS_STG.SS_ADM_APPL_ID%TYPE) IS
3941: SELECT 'x'
3942: FROM IGS_SS_AD_OTHINS_STG
3943: WHERE SS_ADM_APPL_ID = cp_Appl_Num;
3944:
3945: -- Academic Interest- ACAD_INTEREST
3946: CURSOR c_acad_int(cp_Appl_Num IGS_SS_AD_ACADIN_STG.SS_ADM_APPL_ID%TYPE) IS