APPS.IGS_AD_SS_GEN_001 dependencies on IGS_SS_AD_UNITSE_STG

Line 763: FROM igs_ss_ad_unitse_stg

759: */
760:
761: CURSOR c_des_unit_sets IS
762: SELECT unit_set_cd, version_number, rank
763: FROM igs_ss_ad_unitse_stg
764: WHERE ss_admappl_pgm_id =
765: (SELECT ss_admappl_pgm_id
766: FROM igs_ss_app_pgm_stg
767: WHERE ss_adm_appl_id = p_ss_adm_appl_id --p_adm_appl_number

Line 1402: DELETE FROM igs_ss_ad_unitse_stg

1398: WHERE ss_adm_appl_id = p_adm_appl_number
1399: AND person_id = p_person_id;
1400:
1401: --added by nshee during build for Applicant-BOSS SS Bug 2622488
1402: DELETE FROM igs_ss_ad_unitse_stg
1403: WHERE ss_admappl_pgm_id IN
1404: (SELECT ss_admappl_pgm_id
1405: FROM igs_ss_app_pgm_stg
1406: WHERE ss_adm_appl_id = p_adm_appl_number

Line 3796: CURSOR c_dunits(cp_ss_admappl_pgm igs_ss_ad_unitse_stg.ss_admappl_pgm_id%TYPE) IS

3792: FROM IGS_SS_APP_PGM_STG
3793: WHERE ss_adm_appl_id = cp_adm_appl_number;
3794:
3795: -- Desired Majors/Minors- DESIRED_UNITS
3796: CURSOR c_dunits(cp_ss_admappl_pgm igs_ss_ad_unitse_stg.ss_admappl_pgm_id%TYPE) IS
3797: SELECT 'x'
3798: FROM IGS_SS_AD_UNITSE_STG
3799: WHERE ss_admappl_pgm_id = cp_ss_admappl_pgm;
3800:

Line 3798: FROM IGS_SS_AD_UNITSE_STG

3794:
3795: -- Desired Majors/Minors- DESIRED_UNITS
3796: CURSOR c_dunits(cp_ss_admappl_pgm igs_ss_ad_unitse_stg.ss_admappl_pgm_id%TYPE) IS
3797: SELECT 'x'
3798: FROM IGS_SS_AD_UNITSE_STG
3799: WHERE ss_admappl_pgm_id = cp_ss_admappl_pgm;
3800:
3801: -- Educational Goals- EDUC_GOALS
3802: CURSOR c_educ_goals(cp_ss_admappl_pgm igs_ss_ad_unitse_stg.ss_admappl_pgm_id%TYPE) IS

Line 3802: CURSOR c_educ_goals(cp_ss_admappl_pgm igs_ss_ad_unitse_stg.ss_admappl_pgm_id%TYPE) IS

3798: FROM IGS_SS_AD_UNITSE_STG
3799: WHERE ss_admappl_pgm_id = cp_ss_admappl_pgm;
3800:
3801: -- Educational Goals- EDUC_GOALS
3802: CURSOR c_educ_goals(cp_ss_admappl_pgm igs_ss_ad_unitse_stg.ss_admappl_pgm_id%TYPE) IS
3803: SELECT 'x'
3804: FROM IGS_SS_AD_EDUGOA_STG
3805: WHERE ss_admappl_pgm_id = cp_ss_admappl_pgm;
3806: