APPS.PA_INTERFACE_UTILS_PUB SQL Statements

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

Line: 59

    SELECT business_group_id
      INTO X_business_group_id
      FROM pa_implementations;

Line: 97

SELECT 'x'
FROM  fnd_responsibility
WHERE responsibility_id = p_responsibility_id
AND application_id = p_resp_appl_id;

Line: 105

SELECT application_id
FROM  fnd_responsibility
WHERE responsibility_id = p_responsibility_id;

Line: 112

SELECT 'x'
FROM fnd_user
WHERE user_id = p_user_id;

Line: 400

    SELECT accum_period
      FROM pa_project_accum_headers
     WHERE project_id = p_project_id
       AND task_id = 0
       AND resource_list_member_id = 0;

Line: 458

      SELECT pa_start_date, pa_end_date
        INTO p_last_accum_start_date, p_last_accum_end_date
        FROM pa_periods_v
       WHERE period_name = l_prev_accum_period;

Line: 465

      SELECT distinct gl_start_date, gl_end_date
        INTO p_last_accum_start_date, p_last_accum_end_date
        FROM pa_periods_v
       WHERE gl_period_name = l_prev_accum_period;

Line: 728

    pa_pm_message_amg_tbl(i).p_old_message_code     := 'PA_CHECK_DELETE_TASK_FAILED';

Line: 759

    pa_pm_message_amg_tbl(i).p_old_message_code     := 'PA_TOP_TASK_CHILD_NO_DELETE';

Line: 1397

   SELECT   task_name,
            pm_task_reference
   FROM     pa_tasks p
   WHERE p.task_id = p_pa_task_id;