DBA Data[Home] [Help]

APPS.EAM_EXECUTION_JSP SQL Statements

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

Line: 14

    SELECT
            organization_id
      INTO
            X_org_id
      FROM
            hr_organization_units o
     WHERE  name = X_org_name;
Line: 38

    SELECT
            name
      INTO
            X_org_name
      FROM
            hr_organization_units o
     WHERE
            organization_id = X_org_id;
Line: 61

    select to_char(date1, 'YYYY-MM-DD HH24:MI:SS')
    into ret
    from dual;