APPS.HRI_STRUCT_SUMMARY dependencies on PER_ALL_ASSIGNMENTS_F

Line 549: FROM per_all_assignments_f asg

545: , asg.business_group_id
546: , 0 supervisor_hier_level
547: , NVL(asg.last_update_date, g_default_last_update)
548: last_ptntl_change_date
549: FROM per_all_assignments_f asg
550: WHERE DECODE(cp_primary_ass_only, 'Y', asg.primary_flag, 1)
551: = DECODE(cp_primary_ass_only, 'Y', 'Y', 1) -- primary assignments only
552: AND asg.supervisor_id IS NULL -- not supervised themselves.
553: AND asg.assignment_type = 'E'

Line 557: FROM per_all_assignments_f asg

553: AND asg.assignment_type = 'E'
554: AND cp_date BETWEEN asg.effective_start_date AND asg.effective_end_date
555: AND asg.person_id IN
556: (SELECT DISTINCT asg.supervisor_id
557: FROM per_all_assignments_f asg
558: WHERE DECODE(cp_primary_ass_only, 'Y', asg.primary_flag, 1)
559: = DECODE(cp_primary_ass_only, 'Y', 'Y', 1) -- primary assignments only
560: AND asg.supervisor_id IS NOT NULL
561: AND asg.assignment_type = 'E'

Line 587: FROM per_all_assignments_f hier

583: , LEVEL-1 supervisor_level
584: , hier.assignment_id supv_asg_id
585: , NVL(hier.last_update_date, g_default_last_update)
586: last_ptntl_change_date
587: FROM per_all_assignments_f hier
588: WHERE cp_date BETWEEN
589: hier.effective_start_date AND hier.effective_end_date
590: AND hier.assignment_type = 'E'
591: AND DECODE(cp_primary_ass_only, 'Y', hier.primary_flag, 1)

Line 616: FROM per_all_assignments_f hier

612: , hier.primary_flag
613: , LEVEL-1 subordinate_level
614: , NVL(hier.last_update_date, g_default_last_update)
615: last_ptntl_change_date
616: FROM per_all_assignments_f hier
617: WHERE cp_date BETWEEN
618: hier.effective_start_date AND hier.effective_end_date
619: AND hier.assignment_type = 'E'
620: AND DECODE(cp_primary_ass_only, 'Y', hier.primary_flag, 1)