DBA Data[Home] [Help]

APPS.FUN_OPEN_INTERFACE_PKG dependencies on HZ_ORG_CONTACTS

Line 596: hz_org_contacts hc,

592: hz_parties hzp,
593: fnd_grants fg,
594: fnd_object_instance_sets fois,
595: hz_relationships hzr,
596: hz_org_contacts hc,
597: hz_org_contact_roles hcr
598: WHERE hzp.party_type = 'ORGANIZATION'
599: AND EXISTS
600: (SELECT 1

Line 1322: HZ_ORG_CONTACTS HC,

1318: HZ_PARTIES HZP,
1319: FND_GRANTS FG,
1320: FND_OBJECT_INSTANCE_SETS FOIS,
1321: HZ_RELATIONSHIPS HZR,
1322: HZ_ORG_CONTACTS HC,
1323: HZ_ORG_CONTACT_ROLES HCR
1324: WHERE FIB.BATCH_ID=FIH.BATCH_ID
1325: AND FIB.GROUP_ID=:GROUP_ID
1326: AND FIB.IMPORT_STATUS_CODE=''R''

Line 1376: hz_org_contacts hc,

1372: hz_parties hzp,
1373: fnd_grants fg,
1374: fnd_object_instance_sets fois,
1375: hz_relationships hzr,
1376: hz_org_contacts hc,
1377: hz_org_contact_roles hcr
1378: WHERE fib.group_id = rec.group_id
1379: AND fib.import_status_code = 'R'
1380: AND fib.currency_code = rec2.currency_code