DBA Data[Home] [Help]

APPS.HR_DESCR_FLEX_CONTEXT_INFO dependencies on HR_API

Line 94: AND (NVL(g_segment_headers(l_index_number).descr_flex_context_code,hr_api.g_varchar2) = NVL(p_descr_flex_context_code,hr_api.g_varchar2))

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).descriptive_flexfield_name = p_descriptive_flexfield_name)
94: AND (NVL(g_segment_headers(l_index_number).descr_flex_context_code,hr_api.g_varchar2) = NVL(p_descr_flex_context_code,hr_api.g_varchar2))
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;