APPS.IGS_AD_ACAD_HISTORY_PKG dependencies on IGS_PE_HZ_PARTIES

Line 78: FROM igs_pe_hz_parties

74: l_mode VARCHAR2(1);
75:
76: CURSOR c_school_party_id (p_party_number hz_parties.party_number%TYPE) IS
77: SELECT party_id
78: FROM igs_pe_hz_parties
79: WHERE oss_org_unit_cd = p_party_number;
80:
81: CURSOR c_school_attended_name (p_party_number hz_parties.party_number%TYPE) IS
82: SELECT party_name

Line 83: FROM hz_parties hz, igs_pe_hz_parties php

79: WHERE oss_org_unit_cd = p_party_number;
80:
81: CURSOR c_school_attended_name (p_party_number hz_parties.party_number%TYPE) IS
82: SELECT party_name
83: FROM hz_parties hz, igs_pe_hz_parties php
84: WHERE php.oss_org_unit_cd = p_party_number
85: AND php.party_id = hz.party_id ;
86:
87: CURSOR c_degree_code (p_degree hz_education.degree_received%TYPE) IS

Line 95: CURSOR get_dob_dt_cur(p_person_id igs_pe_hz_parties.party_id%TYPE)

91: WHERE dg.degree_cd = p_degree
92: AND dg.closed_ind ='N'
93: AND dg.program_type = ps.course_type;
94:
95: CURSOR get_dob_dt_cur(p_person_id igs_pe_hz_parties.party_id%TYPE)
96: IS
97: SELECT birth_date
98: FROM igs_pe_person_base_v
99: WHERE person_id = p_person_id;

Line 432: FROM igs_pe_hz_parties

428: WHERE EDUCATION_ID = x_Education_Id;
429:
430: CURSOR c_school_party_id (p_party_number hz_parties.party_number%TYPE) IS
431: SELECT party_id
432: FROM igs_pe_hz_parties
433: WHERE oss_org_unit_cd = p_party_number;
434:
435: CURSOR c_school_attended_name (p_party_number hz_parties.party_number%TYPE) IS
436: SELECT party_name

Line 437: FROM hz_parties hz, igs_pe_hz_parties php

433: WHERE oss_org_unit_cd = p_party_number;
434:
435: CURSOR c_school_attended_name (p_party_number hz_parties.party_number%TYPE) IS
436: SELECT party_name
437: FROM hz_parties hz, igs_pe_hz_parties php
438: WHERE php.oss_org_unit_cd = p_party_number
439: AND php.party_id = hz.party_id ;
440:
441: CURSOR c_adv_standing ( p_party_number hz_parties.party_number%TYPE, p_person_id hz_parties.party_id%TYPE) IS

Line 459: CURSOR get_dob_dt_cur(p_person_id igs_pe_hz_parties.party_id%TYPE)

455: SELECT degree_attempted, degree_earned, program_code
456: FROM IGS_AD_ACAD_HISTORY_V ach
457: WHERE ach.education_id = x_education_id;
458:
459: CURSOR get_dob_dt_cur(p_person_id igs_pe_hz_parties.party_id%TYPE)
460: IS
461: SELECT birth_date
462: FROM igs_pe_person_base_v
463: WHERE person_id = p_person_id;