DBA Data[Home] [Help]

APPS.IGF_SL_CL_LI_IMP_PKG dependencies on IGS_OR_ORG_ALT_IDTYP

Line 538: igs_or_org_alt_idtyp olt

534: IS
535: SELECT 1
536: FROM hz_parties hz,
537: igs_or_org_alt_ids oli,
538: igs_or_org_alt_idtyp olt
539: WHERE oli.org_structure_id = hz.party_number
540: AND oli.org_alternate_id_type = olt.org_alternate_id_type
541: AND SYSDATE BETWEEN oli.start_date AND NVL(oli.end_date, SYSDATE)
542: AND hz.status = 'A'

Line 1338: igs_or_org_alt_idtyp olt

1334: IS
1335: SELECT 1
1336: FROM hz_parties hz,
1337: igs_or_org_alt_ids oli,
1338: igs_or_org_alt_idtyp olt
1339: WHERE oli.org_structure_id = hz.party_number
1340: AND oli.org_alternate_id_type = olt.org_alternate_id_type
1341: AND SYSDATE BETWEEN oli.start_date AND NVL(oli.end_date, SYSDATE)
1342: AND hz.status = 'A'