APPS.FII_PARTY_MKT_CLASS_C dependencies on HZ_CODE_ASSIGNMENTS

Line 333: SELECT /*+ PARALLEL(HZ_CODE_ASSIGNMENTS) */

329: g_user_id,
330: g_login_id
331: FROM
332: (
333: SELECT /*+ PARALLEL(HZ_CODE_ASSIGNMENTS) */
334: owner_table_id party_id,
335: class_category,
336: class_code,
337: creation_date,

Line 341: FROM hz_code_assignments

337: creation_date,
338: last_update_date,
339: CASE WHEN primary_flag = 'Y'
340: THEN 2 ELSE 1 END active_priority
341: FROM hz_code_assignments
342: WHERE class_category = g_class_type
343: AND owner_table_name = 'HZ_PARTIES'
344: AND g_collection_to_date BETWEEN start_date_active AND nvl(end_date_active, g_collection_to_date+1)
345: ORDER BY owner_table_id

Line 476: bis_collection_utilities.log('Populating Staging table with incremental records from hz_code_assignments table');

472:
473: l_sql_string := 'TRUNCATE TABLE ' || l_fii_schema ||'.FII_PARTY_MKT_CLASS_STG';
474: EXECUTE IMMEDIATE l_sql_string;
475:
476: bis_collection_utilities.log('Populating Staging table with incremental records from hz_code_assignments table');
477: g_phase := 'Populating Staging table with incremental records from hz_code_assignments table';
478:
479: -- Bug 5093260. Performance enhancement
480: INSERT INTO fii_party_mkt_class_stg

Line 477: g_phase := 'Populating Staging table with incremental records from hz_code_assignments table';

473: l_sql_string := 'TRUNCATE TABLE ' || l_fii_schema ||'.FII_PARTY_MKT_CLASS_STG';
474: EXECUTE IMMEDIATE l_sql_string;
475:
476: bis_collection_utilities.log('Populating Staging table with incremental records from hz_code_assignments table');
477: g_phase := 'Populating Staging table with incremental records from hz_code_assignments table';
478:
479: -- Bug 5093260. Performance enhancement
480: INSERT INTO fii_party_mkt_class_stg
481: (

Line 506: FROM HZ_CODE_ASSIGNMENTS a,

502: g_user_id,
503: a.LAST_UPDATE_DATE,
504: g_user_id,
505: g_login_id
506: FROM HZ_CODE_ASSIGNMENTS a,
507: (
508: SELECT /*+ no_merge parallel(h) */ DISTINCT OWNER_TABLE_ID
509: FROM HZ_CODE_ASSIGNMENTS h
510: WHERE ( (LAST_UPDATE_DATE BETWEEN SYSDATE-1 AND SYSDATE)

Line 509: FROM HZ_CODE_ASSIGNMENTS h

505: g_login_id
506: FROM HZ_CODE_ASSIGNMENTS a,
507: (
508: SELECT /*+ no_merge parallel(h) */ DISTINCT OWNER_TABLE_ID
509: FROM HZ_CODE_ASSIGNMENTS h
510: WHERE ( (LAST_UPDATE_DATE BETWEEN SYSDATE-1 AND SYSDATE)
511: OR
512: (START_DATE_ACTIVE BETWEEN SYSDATE-1 AND SYSDATE)
513: OR