APPS.PQP_WEBADI_INTEGRATION_UTILS SQL Statements

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

Line: 15

SELECT pltl.prompt_left   integrator_code,
       pltl.prompt_above  layout_code
FROM   bne_param_lists_b  plb,
       bne_param_lists_tl pltl
WHERE  plb.param_list_code = p_caller_identifier
AND    plb.param_list_code = pltl.param_list_code
AND    decode(pltl.user_tip, NULL, 'Y', decode(substr(pltl.user_tip,1,1), '+',
       decode(sign(instr(pltl.user_tip, HR_API.GET_LEGISLATION_CONTEXT)), 1, 'Y', 'N'), '-', decode(sign(instr(pltl.user_tip,
       HR_API.GET_LEGISLATION_CONTEXT)), 1, 'N', 'Y'), 'Y' ) ) = 'Y'
AND    pltl.application_id = p_application_id
AND    plb.application_id  = p_application_id
AND    pltl.language = userenv('lang');

Line: 29

   SELECT viewer_code,
          user_name
   FROM   bne_viewers_tl
   WHERE  viewer_code IN ('EXCEL97', 'EXCEL2000', 'EXCELXP')
   and language = userenv('lang');