APPS.FII_PARTY_MKT_CLASS_C dependencies on HZ_CUST_ACCOUNTS

Line 379: ( SELECT /*+ PARALLEL(HZ_CUST_ACCOUNTS) */

375: sysdate last_update_date,
376: g_user_id last_updated_by,
377: g_login_id last_update_login
378: FROM
379: ( SELECT /*+ PARALLEL(HZ_CUST_ACCOUNTS) */
380: DISTINCT party_id
381: FROM hz_cust_accounts
382: WHERE party_id NOT IN (SELECT /*+ PARALLEL(FII_PARTY_MKT_CLASS) */
383: party_id

Line 381: FROM hz_cust_accounts

377: g_login_id last_update_login
378: FROM
379: ( SELECT /*+ PARALLEL(HZ_CUST_ACCOUNTS) */
380: DISTINCT party_id
381: FROM hz_cust_accounts
382: WHERE party_id NOT IN (SELECT /*+ PARALLEL(FII_PARTY_MKT_CLASS) */
383: party_id
384: FROM fii_party_mkt_class
385: WHERE class_category = g_class_type

Line 561: FROM HZ_CUST_ACCOUNTS a

557: g_user_id last_updated_by,
558: g_login_id last_update_login
559: FROM (
560: SELECT /*+ parallel(a) */ DISTINCT PARTY_ID
561: FROM HZ_CUST_ACCOUNTS a
562: WHERE CREATION_DATE BETWEEN g_collection_from_date AND g_collection_to_date
563: AND PARTY_ID NOT IN (
564: SELECT /*+ parallel(s) */ OWNER_TABLE_ID
565: FROM FII_PARTY_MKT_CLASS_STG s