APPS.PA_PAY_UTIL SQL Statements

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

Line: 4

PROCEDURE update_pa_audit
(
  P_PAYROLL_ACTION_ID IN  NUMBER
, P_PAYROLL_ID        IN  NUMBER
, P_TIME_PERIOD_ID    IN  VARCHAR2
, P_PERSON_ID         IN  NUMBER
, P_ASSIGNMENT_ID     IN  NUMBER
, X_RETURN_STATUS     OUT NOCOPY VARCHAR2
) IS
BEGIN
		UPDATE PA_PAY_PROJ_STATUS_ALL
		SET    PAYROLL_STATUS_FLAG = 'R'
		WHERE  INTERFACE_RUN_ID IN
		(SELECT INTERFACE_RUN_ID
		FROM    PA_PAY_AUDIT_ALL
		WHERE   BATCH_ID = P_PAYROLL_ACTION_ID
		AND     TIME_PERIOD_ID = P_TIME_PERIOD_ID
		AND     PAYROLL_ID        = P_PAYROLL_ID
		AND     INT_EXT_INDICATOR = 'INT'
		)
		AND    PERSON_ID     = P_PERSON_ID
		AND    ASSIGNMENT_ID = P_ASSIGNMENT_ID ;

Line: 27

END update_pa_audit;

Line: 38

      select task_number
        into l_task_number
        from pa_tasks
       where task_id = (select task_id
                          from pa_expenditure_items_all
                         where expenditure_item_id = pa_pay_util.g_expenditure_item_id);

Line: 63

      select segment1
        into l_project_number
        from pa_projects_all
       where project_id = (select project_id
                             from pa_expenditure_items_all
                            where expenditure_item_id = pa_pay_util.g_expenditure_item_id);

Line: 88

      select name
        into l_job_name
        from per_jobs_v
       where job_id = (select job_id
                         from pa_expenditure_items_all
                        where expenditure_item_id = pa_pay_util.g_expenditure_item_id);

Line: 112

      select location_code
        into l_location_code
        from hr_locations
       where location_id = (select location_id
                               from pa_expenditure_items_all
                              where expenditure_item_id = pa_pay_util.g_expenditure_item_id);

Line: 136

      select name
        into l_work_type_name
        from pa_work_types_vl
       where work_type_id = (select work_type_id
                               from pa_expenditure_items_all
                              where expenditure_item_id = pa_pay_util.g_expenditure_item_id);

Line: 186

  select business_group_id
    into l_business_group_id
    from pa_implementations;