APPS.IGS_EN_NSC_PKG dependencies on HZ_PARTIES

Line 276: FROM igs_en_stdnt_ps_Att spa , igs_ps_ver vers, hz_parties hp, igs_pe_hz_parties ihp,

272: --such that they belong to the local institution .
273:
274: CURSOR c_course (cp_nslc_condition VARCHAR2 )IS
275: SELECT DISTINCT spa.course_cd, spa.version_number, hp.party_id org_id, ihp.oss_org_unit_cd org_unit_cd
276: FROM igs_en_stdnt_ps_Att spa , igs_ps_ver vers, hz_parties hp, igs_pe_hz_parties ihp,
277: igs_or_status os
278: WHERE vers.course_cd=spa.course_cd
279: AND vers.version_number=spa.version_number
280: AND spa.cal_type = l_acad_cal_type

Line 422: WHERE parent_org_unit_cd IN (SELECT ihp.oss_org_unit_cd org_unit_cd FROM hz_parties hp, igs_pe_hz_parties ihp

418: --The where clause filters the final hierarchy to see if a branch org under the institution has been reached.
419: CURSOR c_validate_org_all (cp_org_unit_cd igs_or_unit_v.org_unit_cd%TYPE) IS
420: SELECT cst_valid
421: FROM igs_or_unit_rel
422: WHERE parent_org_unit_cd IN (SELECT ihp.oss_org_unit_cd org_unit_cd FROM hz_parties hp, igs_pe_hz_parties ihp
423: WHERE hp.party_id = ihp.party_id AND ihp.inst_org_ind = 'O'
424: AND ihp.institution_cd = g_school_id)
425: CONNECT BY child_org_unit_cd=PRIOR parent_org_unit_cd
426: AND igs_en_nsc_pkg.org_alt_check(child_org_unit_cd) IS NULL

Line 432: SELECT cst_valid FROM hz_parties hp, igs_pe_hz_parties ihp

428: AND igs_en_nsc_pkg.org_alt_check(cp_org_unit_cd) IS NULL;
429:
430: --c_validate_org_all_inst returns valid if org is directly under the institution
431: CURSOR c_validate_org_all_inst (cp_org_unit_cd igs_or_unit_v.org_unit_cd%TYPE) IS
432: SELECT cst_valid FROM hz_parties hp, igs_pe_hz_parties ihp
433: WHERE hp.party_id = ihp.party_id AND ihp.inst_org_ind = 'O'
434: AND ihp.oss_org_unit_cd = cp_org_unit_cd
435: AND ihp.party_id = hp.party_id
436: AND ihp.institution_cd = g_school_id

Line 1424: FROM hz_parties P, hz_person_profiles PP

1420: p.person_first_name given_names,
1421: p.person_middle_name middle_name,
1422: p.person_name_suffix suffix,
1423: pp.date_of_birth birth_dt
1424: FROM hz_parties P, hz_person_profiles PP
1425: WHERE p.party_id = p_student_data.student_id
1426: AND p.party_id = pp.party_id
1427: AND pp.content_source_type = 'USER_ENTERED'
1428: AND SYSDATE BETWEEN pp.effective_start_date AND NVL(pp.effective_end_date,SYSDATE);

Line 1787: FROM igs_pe_hz_parties pd, hz_person_profiles pp

1783:
1784: /* For deceased date..cursor is changed from igs_pe_person to underlying tables */
1785: CURSOR c_decease_date IS
1786: SELECT NVL(pp.date_of_death,SYSDATE)
1787: FROM igs_pe_hz_parties pd, hz_person_profiles pp
1788: WHERE DECODE(pp.date_of_death,NULL,NVL(pd.deceased_ind,'N'),'Y')='Y'
1789: AND pp.party_id = p_student_id
1790: AND pp.party_id = pd.party_id (+)
1791: AND pp.content_source_type = 'USER_ENTERED'