DBA Data[Home] [Help]

APPS.HR_ID_FLEX_STRUCTURE_INFO dependencies on HR_API

Line 94: AND (NVL(g_segment_headers(l_index_number).id_flex_num,hr_api.g_number) = NVL(p_id_flex_num,hr_api.g_number))

90: AND (NOT l_segments_exist)
91: LOOP
92: IF (g_segment_headers(l_index_number).application_id = p_application_id)
93: AND (g_segment_headers(l_index_number).id_flex_code = p_id_flex_code)
94: AND (NVL(g_segment_headers(l_index_number).id_flex_num,hr_api.g_number) = NVL(p_id_flex_num,hr_api.g_number))
95: AND (g_segment_headers(l_index_number).effective_date = p_effective_date)
96: THEN
97: l_first_index_number := g_segment_headers(l_index_number).first_index_number;
98: l_last_index_number := g_segment_headers(l_index_number).last_index_number;