APPS.IMC_REPORTS_SUMMARY_PKG dependencies on HZ_ORGANIZATION_PROFILES

Line 1309: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op

1305:
1306: -- get party count of organization
1307: cursor get_org_count is
1308: SELECT count(1)
1309: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op
1310: WHERE p.status in ('A','I')
1311: AND p.party_type = 'ORGANIZATION'
1312: AND p.party_id = op.party_id
1313: AND sysdate between op.effective_start_date and nvl(op.effective_end_date, sysdate);

Line 1584: ELSIF((p_table_name = 'HZ_ORGANIZATION_PROFILES') OR (p_table_name = 'HZ_PERSON_PROFILES')) THEN

1580: l_perf_hint := ' /*+ PARALLEL(rt) PARALLEL(ca) PARALLEL(pty) PARALLEL(r) PARALLEL(oc) */ ';
1581: ELSE
1582: l_perf_hint := ' /*+ PARALLEL(pty) */ ';
1583: END IF;
1584: ELSIF((p_table_name = 'HZ_ORGANIZATION_PROFILES') OR (p_table_name = 'HZ_PERSON_PROFILES')) THEN
1585: table_prefix := 'prof.';
1586: fromandwhere_str := get_profile_clause(p_table_name, p_party_type, p_system_date, x_return_status);
1587: -- Perf Bug 6322629 (Add parallel hint for profile tables as volume of data is too high)
1588: l_perf_hint := ' /*+ PARALLEL(prof) PARALLEL(pty) */ ';

Line 1628: IF((p_table_name = 'HZ_ORGANIZATION_PROFILES') OR (p_table_name = 'HZ_PERSON_PROFILES') OR (p_table_name = 'HZ_CODE_ASSIGNMENTS')) THEN

1624: ':p_date '||fromandwhere_str;
1625:
1626: write_log('>> sql string: '||str);
1627:
1628: IF((p_table_name = 'HZ_ORGANIZATION_PROFILES') OR (p_table_name = 'HZ_PERSON_PROFILES') OR (p_table_name = 'HZ_CODE_ASSIGNMENTS')) THEN
1629: execute immediate str using p_system_date, p_system_date, p_system_date;
1630: ELSE
1631: execute immediate str using p_system_date;
1632: END IF;