APPS.IGS_EN_NSC_PKG dependencies on IGS_OR_UNIT_REL

Line 406: FROM igs_or_unit_rel

402: --The condition after the connect by stops the recursion when the Branch org is reached and prunes branches with alt ids
403: --The where clause filters the final hierarchy to see if te Branch org has been reached.
404: CURSOR c_validate_org_branch (cp_org_unit_cd igs_or_unit_v.org_unit_cd%TYPE) IS
405: SELECT cst_valid
406: FROM igs_or_unit_rel
407: WHERE parent_org_unit_cd=g_branch_id
408: CONNECT BY child_org_unit_cd=PRIOR parent_org_unit_cd
409: AND child_org_unit_cd<>g_branch_id AND igs_en_nsc_pkg.org_alt_check(child_org_unit_cd) IS NULL
410: START WITH child_org_unit_cd=cp_org_unit_cd

Line 421: FROM igs_or_unit_rel

417: --The condition after the connect by prunes branches with alt ids
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