APPS.IMC_REPORTS_SUMMARY_PKG dependencies on HZ_PERSON_PROFILES

Line 1318: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pp

1314:
1315: -- get party count of person
1316: cursor get_per_count is
1317: SELECT count(1)
1318: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pp
1319: WHERE p.status in ('A','I')
1320: AND p.party_type = 'PERSON'
1321: AND p.party_id = pp.party_id
1322: AND sysdate between pp.effective_start_date and nvl(pp.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;