APPS.IGS_AZ_GEN_001 dependencies on HZ_PARTIES

Line 1114: hz_parties p

1110: azs.*,
1111: p.party_number,
1112: p.party_name
1113: FROM igs_az_students azs ,
1114: hz_parties p
1115: WHERE azs.group_name = cp_group_name
1116: AND azs.advising_hold_type IS NULL
1117: AND azs.hold_start_date IS NULL
1118: AND azs.start_date IS NOT NULL

Line 1133: cp_person_id hz_parties.party_id%TYPE) IS

1129: -- Cursor to check if the Hold already existes for the Student
1130: --
1131: CURSOR cur_stu_encumb (
1132: cp_encumbrance_type igs_pe_pers_encumb.encumbrance_type%TYPE,
1133: cp_person_id hz_parties.party_id%TYPE) IS
1134: SELECT encumbrance_type,
1135: start_dt
1136: FROM igs_pe_pers_encumb
1137: WHERE encumbrance_type = cp_encumbrance_type

Line 1376: FROM igs_az_students azs, hz_parties p

1372: SELECT azs.ROWID AS row_id,
1373: azs.*,
1374: p.party_number,
1375: p.party_name
1376: FROM igs_az_students azs, hz_parties p
1377: WHERE azs.group_name = p_group_name
1378: AND azs.accept_add_flag = 'Y'
1379: AND azs.start_date IS NOT NULL
1380: AND azs.end_date IS NULL

Line 1391: FROM igs_az_students azs, hz_parties p

1387: SELECT azs.ROWID AS row_id,
1388: azs.*,
1389: p.party_number,
1390: p.party_name
1391: FROM igs_az_students azs, hz_parties p
1392: WHERE azs.group_name = p_group_name
1393: AND azs.accept_add_flag = 'Y'
1394: AND azs.notified_date IS NULL
1395: AND azs.start_date IS NOT NULL

Line 1406: FROM igs_az_advisors aza, igs_az_groups azg, hz_parties p

1402: SELECT aza.ROWID AS row_id,
1403: aza.*,
1404: p.party_number,
1405: p.party_name
1406: FROM igs_az_advisors aza, igs_az_groups azg, hz_parties p
1407: WHERE aza.group_name = p_group_name
1408: AND aza.accept_add_flag = 'Y'
1409: AND aza.start_date IS NOT NULL
1410: AND aza.end_date IS NULL

Line 1424: FROM igs_az_advisors aza, igs_az_groups azg, hz_parties p

1420: SELECT aza.ROWID AS row_id,
1421: aza.*,
1422: p.party_number,
1423: p.party_name
1424: FROM igs_az_advisors aza, igs_az_groups azg, hz_parties p
1425: WHERE aza.group_name = p_group_name
1426: AND aza.accept_add_flag = 'Y'
1427: AND aza.start_date IS NOT NULL
1428: AND aza.notified_date IS NULL