APPS.IGS_AD_SS_GEN_001 dependencies on IGS_SS_AD_EDUGOA_STG

Line 1156: FROM igs_ss_ad_edugoa_stg

1152: l_post_edugoal_id IGS_AD_EDUGOAL.post_edugoal_id%TYPE;
1153: lv_mode VARCHAR2(1) DEFAULT 'R';
1154: CURSOR c_postenroll_edu_goal IS
1155: SELECT edu_goal_id
1156: FROM igs_ss_ad_edugoa_stg
1157: WHERE ss_admappl_pgm_id =
1158: (SELECT ss_admappl_pgm_id
1159: FROM igs_ss_app_pgm_stg
1160: WHERE ss_adm_appl_id = p_ss_adm_appl_id -- p_adm_appl_number

Line 1409: DELETE FROM igs_ss_ad_edugoa_stg

1405: FROM igs_ss_app_pgm_stg
1406: WHERE ss_adm_appl_id = p_adm_appl_number
1407: AND person_id = p_person_id);
1408:
1409: DELETE FROM igs_ss_ad_edugoa_stg
1410: WHERE ss_admappl_pgm_id IN
1411: (SELECT ss_admappl_pgm_id
1412: FROM igs_ss_app_pgm_stg
1413: WHERE ss_adm_appl_id = p_adm_appl_number

Line 3804: FROM IGS_SS_AD_EDUGOA_STG

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:
3807: -- Financial Aid- FIN_AID
3808: CURSOR c_fin_aid(cp_adm_appl_number IGS_SS_APP_PGM_STG.ss_adm_appl_id%TYPE) IS