APPS.IGF_SL_GEN dependencies on IGS_PS_VER_ALL

Line 1294: CURSOR c_get_org_enr (cp_course_cd igs_ps_ver_all.course_cd%TYPE,

1290: || (reverse chronological order - newest change first)
1291: */
1292:
1293: -- get Org Unit from program that is obatined as key program from enrollment api
1294: CURSOR c_get_org_enr (cp_course_cd igs_ps_ver_all.course_cd%TYPE,
1295: cp_version_number igs_ps_ver_all.version_number%TYPE) IS
1296: SELECT ps.responsible_org_unit_cd org_unit_cd,
1297: hz.party_id
1298: FROM igs_ps_ver_all ps,

Line 1295: cp_version_number igs_ps_ver_all.version_number%TYPE) IS

1291: */
1292:
1293: -- get Org Unit from program that is obatined as key program from enrollment api
1294: CURSOR c_get_org_enr (cp_course_cd igs_ps_ver_all.course_cd%TYPE,
1295: cp_version_number igs_ps_ver_all.version_number%TYPE) IS
1296: SELECT ps.responsible_org_unit_cd org_unit_cd,
1297: hz.party_id
1298: FROM igs_ps_ver_all ps,
1299: hz_parties hz

Line 1298: FROM igs_ps_ver_all ps,

1294: CURSOR c_get_org_enr (cp_course_cd igs_ps_ver_all.course_cd%TYPE,
1295: cp_version_number igs_ps_ver_all.version_number%TYPE) IS
1296: SELECT ps.responsible_org_unit_cd org_unit_cd,
1297: hz.party_id
1298: FROM igs_ps_ver_all ps,
1299: hz_parties hz
1300: WHERE hz.party_number = ps.responsible_org_unit_cd
1301: AND ps.course_cd = cp_course_cd
1302: AND ps.version_number = cp_version_number;

Line 1335: FROM igs_ps_ver_all ps,

1331: SELECT ps.responsible_org_unit_cd,
1332: hz.party_name,
1333: hz.party_id,
1334: count(*) NUM_OF_RECORDS
1335: FROM igs_ps_ver_all ps,
1336: hz_parties hz,
1337: igs_ad_appl_all appl,
1338: igs_ad_ps_appl_inst applinst,
1339: igs_ad_appl_stat_v igsl1,

Line 1370: x_key_program_course_cd igs_ps_ver_all.course_cd%TYPE;

1366: AND fa.assoc_org_num = hz.party_id;
1367: c_get_assoc_org_rec c_get_assoc_org%ROWTYPE;
1368:
1369: l_person_id hz_parties.party_id%TYPE;
1370: x_key_program_course_cd igs_ps_ver_all.course_cd%TYPE;
1371: x_version_number igs_ps_ver_all.version_number%TYPE;
1372:
1373:
1374: BEGIN

Line 1371: x_version_number igs_ps_ver_all.version_number%TYPE;

1367: c_get_assoc_org_rec c_get_assoc_org%ROWTYPE;
1368:
1369: l_person_id hz_parties.party_id%TYPE;
1370: x_key_program_course_cd igs_ps_ver_all.course_cd%TYPE;
1371: x_version_number igs_ps_ver_all.version_number%TYPE;
1372:
1373:
1374: BEGIN
1375: -- initialize

Line 2026: igs_ps_ver_all prog

2022: SELECT prog.*
2023: FROM
2024: igf_aw_awd_ld_cal_v awd_year_terms,
2025: igf_ap_fa_ant_data ant_data,
2026: igs_ps_ver_all prog
2027: WHERE
2028: ant_data.ld_cal_type = awd_year_terms.ld_cal_type AND
2029: ant_data.ld_sequence_number = awd_year_terms.ld_sequence_number AND
2030: ant_data.base_id = cp_base_id and