APPS.PQP_GB_OMP_EARNINGS SQL Statements

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

Line: 25

SELECT user_entered, average_earnings_amount
  FROM ssp_earnings_calculations
 WHERE person_id      = p_person_id
   AND effective_date = p_effective_date ;

Line: 31

SELECT person_id
  FROM per_assignments_f
 WHERE assignment_id = p_assignment_id ;