APPS.PA_HR_BILL_RATES SQL Statements

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

Line: 13

         select  null
         from    pa_emp_bill_rate_overrides      pa
         where   pa.project_id > -1
         and   pa.task_id    > -1
         and   pa.person_id                    = P_PERSON_ID;

Line: 20

         select  null
         from    pa_job_assignment_overrides     pa
         where ((pa.project_id > -1   AND
         pa.person_id                    = P_PERSON_ID)
         OR
         (pa.task_id > -1      AND
         pa.person_id                    = P_PERSON_ID));

Line: 29

                select
                        null
                from    pa_bill_rates_all                   pa
                where   pa.bill_rate_organization_id > -1
                  and   pa.std_bill_rate_schedule <> 'DUMMY'
                  and   pa.person_id                    = P_PERSON_ID;

Line: 82

         select  null
         from    pa_bill_rates_all   pa
         where   pa.job_id           = P_JOB_ID;

Line: 87

         select  null
         from    pa_job_assignment_overrides    pa
         where   pa.job_id                    = P_JOB_ID;

Line: 92

         select  null
         from    PA_JOB_BILL_RATE_OVERRIDES    pa
         where   pa.job_id                    = P_JOB_ID;

Line: 97

         select  null
         from    PA_JOB_BILL_TITLE_OVERRIDES    pa
         where   pa.job_id                    = P_JOB_ID;