eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_NSC_PKG dependencies on IGS_OR_ORG_ALT_IDS

Line 443: FROM igs_or_org_alt_ids alt

439:
440:
441: CURSOR c_org_unit_cd(g_branch_id VARCHAR2, l_branch_code VARCHAR2) IS
442: SELECT DISTINCT org_structure_id
443: FROM igs_or_org_alt_ids alt
444: WHERE NVL(alt.end_date, SYSDATE) >= SYSDATE
445: AND NVL(alt.start_date,SYSDATE) <= SYSDATE
446: AND org_alternate_id = g_branch_id
447: AND org_alternate_id_type = l_branch_code

Line 453: FROM igs_or_org_alt_ids alt, igs_or_institution inst

449:
450: -- Cursor to get the org_structure_id for the passed alternate code
451: CURSOR c_school_code IS
452: SELECT alt.org_structure_id
453: FROM igs_or_org_alt_ids alt, igs_or_institution inst
454: WHERE alt.org_structure_id = inst.institution_cd
455: AND alt.org_structure_type = 'INSTITUTE'
456: AND NVL(alt.end_date, SYSDATE) >= SYSDATE
457: AND inst.local_institution_ind = 'Y'

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