APPS.HRI_BPL_SETUP_DIAGNOSTIC dependencies on PER_PERIODS_OF_SERVICE

Line 792: FROM per_periods_of_service pps

788: AND seg.id_flex_num = hoi.org_information6
789: AND seg.flex_value_set_id = v_valueset_id)
790: AND EXISTS
791: (SELECT /*+ NO_UNNEST */ null
792: FROM per_periods_of_service pps
793: WHERE pps.business_group_id = hoi.organization_id
794: AND NVL(pps.actual_termination_date, g_global_start_date) >= g_global_start_date);
795:
796: -- Cursor to find all non global job descriptive flexfield contexts that