APPS.HR_DFLEX_UTILITY SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 40

     select 'Y'
       from FND_APPLICATION a,
            FND_DESCR_FLEX_CONTEXTS dfc
      where a.application_short_name = p_appl_short_name
        and a.application_id = dfc.application_id
        and dfc.DESCRIPTIVE_FLEXFIELD_NAME = p_flexfield_name
        and dfc.DESCRIPTIVE_FLEX_CONTEXT_CODE = p_context;

Line: 370

   g_dfcode_structure.delete;

Line: 479

       select EFFECTIVE_DATE from fnd_sessions
       where session_id=userenv('sessionid');