APPS.HR_SA_HIJRAH_FUNCTIONS SQL Statements

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

Line: 40

      select to_char                             /* Bug No : 6823109 */
             (
                to_date
                (  l_input_date,'YYYY/MM/DD','NLS_CALENDAR=''ENGLISH HIJRAH'''
                )
                ,'YYYY/MM/DD'
             )
         into l_date
      from dual;

Line: 133

      select to_char
             (
                to_date
                ( l_input_date,'RRRR-MM-DD'
                )
                ,'YYYY/MM/DD','NLS_CALENDAR=''ENGLISH HIJRAH'''
              )
        into l_hij_date
      from dual ;

Line: 193

    select ltrim(rtrim(to_char(l_greg_date,'D')))
    into   l_day
    from   dual;

Line: 220

    select ltrim(rtrim(to_char(l_greg_date,'D')))
    into   l_day
    from   dual;