APPS.PAY_SPR_SHD SQL Statements

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

Line: 70

    select
       business_group_id
      ,security_profile_id
      ,payroll_id
      ,request_id
      ,program_application_id
      ,program_id
      ,program_update_date
      ,object_version_number
    from        pay_security_payrolls
    where       security_profile_id = p_security_profile_id
    and   payroll_id = p_payroll_id;

Line: 148

    select
       business_group_id
      ,security_profile_id
      ,payroll_id
      ,request_id
      ,program_application_id
      ,program_id
      ,program_update_date
      ,object_version_number
    from        pay_security_payrolls
    where       security_profile_id = p_security_profile_id
    and   payroll_id = p_payroll_id
    for update nowait;