APPS.IGF_SL_GEN dependencies on IGS_OR_ORG_ALT_IDTYP

Line 1520: igs_or_org_alt_idtyp idt

1516: CURSOR c_get_fa_office( p_org_unit_cd IN hz_parties.party_number%TYPE,
1517: p_office_type IN igs_lookups_view.lookup_code%TYPE) IS
1518: SELECT org.org_alternate_id office_cd
1519: FROM igs_or_org_alt_ids org,
1520: igs_or_org_alt_idtyp idt
1521: WHERE org.org_structure_id = p_org_unit_cd
1522: AND org.org_alternate_id_type = idt.org_alternate_id_type
1523: AND SYSDATE BETWEEN org.start_date AND NVL(org.end_date, SYSDATE)
1524: AND idt.system_id_type = p_office_type;

Line 2045: igs_or_org_alt_idtyp idt

2041: CURSOR c_get_fa_office( p_org_unit_cd IN hz_parties.party_number%TYPE,
2042: p_office_type IN igs_lookups_view.lookup_code%TYPE) IS
2043: SELECT org.org_alternate_id office_cd
2044: FROM igs_or_org_alt_ids org,
2045: igs_or_org_alt_idtyp idt
2046: WHERE org.org_structure_id = p_org_unit_cd
2047: AND org.org_alternate_id_type = idt.org_alternate_id_type
2048: AND SYSDATE BETWEEN org.start_date AND NVL(org.end_date, SYSDATE)
2049: AND idt.system_id_type = p_office_type;