DBA Data[Home] [Help]

APPS.IGF_AP_ISIR_IMPORT_PKG dependencies on IGS_OR_ORG_ALT_IDTYP

Line 341: igs_or_org_alt_idtyp olt

337: 'Y'
338: FROM
339: hz_parties hz,
340: igs_or_org_alt_ids oli,
341: igs_or_org_alt_idtyp olt
342: WHERE oli.org_structure_id = hz.party_number
343: AND oli.org_alternate_id_type = olt.org_alternate_id_type
344: AND SYSDATE BETWEEN oli.start_date AND nvl (end_date, SYSDATE)
345: AND hz.status = 'A'