APPS.PJI_AUDIT_RPT dependencies on HRI_ORG_HRCHY_SUMMARY

Line 296: FROM hri_org_hrchy_summary

292: INTO l_org_dim
293: FROM dual
294: WHERE EXISTS (
295: SELECT 1
296: FROM hri_org_hrchy_summary
297: );
298: EXCEPTION
299: WHEN NO_DATA_FOUND THEN
300: l_org_dim := null;

Line 439: select /*+ index_ffs(hrchy, HRI_ORG_HRCHY_SUMMARY_N1)

435: p_params_profit_flag = 'N')) and
436: psc.project_status_code = prj.project_status_code
437: ) org,
438: (
439: select /*+ index_ffs(hrchy, HRI_ORG_HRCHY_SUMMARY_N1)
440: parallel_index(hrchy, HRI_ORG_HRCHY_SUMMARY_N1) */
441: distinct
442: hrchy.ORGANIZATION_ID
443: from

Line 440: parallel_index(hrchy, HRI_ORG_HRCHY_SUMMARY_N1) */

436: psc.project_status_code = prj.project_status_code
437: ) org,
438: (
439: select /*+ index_ffs(hrchy, HRI_ORG_HRCHY_SUMMARY_N1)
440: parallel_index(hrchy, HRI_ORG_HRCHY_SUMMARY_N1) */
441: distinct
442: hrchy.ORGANIZATION_ID
443: from
444: HRI_ORG_HRCHY_SUMMARY hrchy

Line 444: HRI_ORG_HRCHY_SUMMARY hrchy

440: parallel_index(hrchy, HRI_ORG_HRCHY_SUMMARY_N1) */
441: distinct
442: hrchy.ORGANIZATION_ID
443: from
444: HRI_ORG_HRCHY_SUMMARY hrchy
445: where
446: ((p_settings_cost_flag = 'Y' and
447: p_params_cost_flag = 'N') or
448: (p_settings_profit_flag = 'Y' and