DBA Data[Home] [Help]

APPS.IGS_EN_NSC_PKG dependencies on IGS_OR_ORG_ALT_IDTYP

Line 3170: FROM igs_or_org_alt_ids alt, igs_or_org_alt_idtyp types

3166: RETURN VARCHAR2 IS
3167:
3168: CURSOR c_alt_id IS
3169: SELECT org_structure_id
3170: FROM igs_or_org_alt_ids alt, igs_or_org_alt_idtyp types
3171: WHERE alt.org_structure_id=p_org_id
3172: AND NVL(alt.end_date, SYSDATE) >= SYSDATE
3173: AND NVL(alt.start_date,SYSDATE) <= SYSDATE
3174: AND alt.org_alternate_id_type = types.org_alternate_id_type