DBA Data[Home] [Help]

APPS.FUN_OPEN_INTERFACE_PKG dependencies on HZ_ORG_CONTACT_ROLES

Line 597: hz_org_contact_roles hcr

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
601: FROM hz_party_usg_assignments hua

Line 1323: HZ_ORG_CONTACT_ROLES HCR

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''
1327: AND FIB.CURRENCY_CODE=:CURRENCY_CODE

Line 1377: hz_org_contact_roles hcr

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
1381: AND fib.from_le_name = rec3.from_le_name