APPS.HRI_STRUCT_SUMMARY dependencies on HRI_SUPV_HRCHY_SUMMARY

Line 494: -- TABLE: HRI_SUPV_HRCHY_SUMMARY

490: --------------------------------------------------------------------------------
491: --------------------------------------------------------------------------------
492: -- SUPERVISOR HIERARCHY FUNCTIONS
493: --
494: -- TABLE: HRI_SUPV_HRCHY_SUMMARY
495: --------------------------------------------------------------------------------
496: --------------------------------------------------------------------------------
497:
498: --------------------------------------------------------------------------------

Line 637: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_SUPV_HRCHY_SUMMARY';

633: -- Bug 3658473: Changed delete to truncate
634: --
635: IF fnd_installation.get_app_info('HRI',l_dummy1, l_dummy2, l_schema) THEN
636: --
637: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_SUPV_HRCHY_SUMMARY';
638: EXECUTE IMMEDIATE(l_sql_stmt);
639: --
640: END IF;
641:

Line 678: INSERT INTO hri_supv_hrchy_summary(

674: THEN
675:
676: -- insert into hri_supv_struct_summary table
677: BEGIN
678: INSERT INTO hri_supv_hrchy_summary(
679: supv_business_group_id
680: , supv_person_id
681: , supv_assignment_id
682: , supv_level

Line 690: /* -- This done by trigger HRI_SUPV_HRCHY_SUMMARY_WHO

686: , sub_assignment_id
687: , sub_primary_asg_flag
688: , sub_level
689: , sub_last_ptntl_change
690: /* -- This done by trigger HRI_SUPV_HRCHY_SUMMARY_WHO
691: , creation_date
692: , created_by
693: , last_update_date
694: , last_updated_by

Line 710: /* -- This done by trigger HRI_SUPV_HRCHY_SUMMARY_WHO

706: , cur_reports_rec.assignment_id
707: , cur_reports_rec.primary_flag
708: , cur_reports_rec.subordinate_level + cur_supervisors_rec.supervisor_level
709: , l_sup_updates_tab(cur_reports_rec.person_id)
710: /* -- This done by trigger HRI_SUPV_HRCHY_SUMMARY_WHO
711: , SYSDATE
712: , -1
713: , SYSDATE
714: , -1