APPS.PAY_CA_PMED SQL Statements

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

Line: 30

  SELECT pma.source_id
  FROM   pay_ca_pmed_accounts        pma
  WHERE  pma.account_number    = p_ac_no
  AND    pma.enabled           = 'Y'
  AND    pma.business_group_id = p_bg_no;

Line: 38

  SELECT pma.source_id,
         pma.account_number
  FROM   hr_organization_information ogi1,
         hr_organization_information ogi2,
         pay_ca_pmed_accounts        pma,
         hr_organization_information ogi3,
         hr_organization_information ogi4
  WHERE  ogi1.organization_id  = p_gre
  AND    ogi1.org_information_context = 'CLASS'
  AND    ogi1.org_information1 = 'HR_LEGAL'
  AND    ogi1.org_information2 = 'Y'
  AND    ogi2.organization_id  = p_gre
  AND    ogi2.org_information_context = 'Provincial Reporting Info.'
  AND    ogi2.org_information1 = p_juris
  AND    ogi2.org_information3 = pma.account_number
  AND    pma.enabled           = 'Y'
  AND    pma.business_group_id = p_bg_no
  AND    ogi3.organization_id   = pma.organization_id
  AND    ogi3.org_information_context = 'CLASS'
  AND    ogi3.org_information1 = 'CA_PMED'
  AND    ogi3.org_information2 = 'Y'
  AND    ogi4.organization_id   = pma.organization_id
  AND    ogi4.org_information_context = 'Provincial Information'
  AND    ogi4.org_information1 = p_juris;

Line: 65

  SELECT pma.source_id,
         pma.account_number
  FROM   hr_organization_information ogi1,
         hr_organization_information ogi2,
         pay_ca_pmed_accounts        pma,
         hr_organization_information ogi3,
         hr_organization_information ogi4
  WHERE  ogi1.organization_id  = p_gre
  AND    ogi1.org_information_context = 'CLASS'
  AND    ogi1.org_information1 = 'HR_LEGAL'
  AND    ogi1.org_information2 = 'Y'
  AND    ogi2.organization_id  = p_gre
  AND    ogi2.org_information_context = 'Provincial Reporting Info.'
  AND    ogi2.org_information1 = p_juris
  AND    ogi2.org_information3 = pma.account_number
  AND    pma.enabled           = 'Y'
  AND    pma.business_group_id = p_bg_no
  AND    ogi3.organization_id   = pma.organization_id
  AND    ogi3.org_information_context = 'CLASS'
  AND    ogi3.org_information1 = 'CA_PMED'
  AND    ogi3.org_information2 = 'Y'
  AND    ogi4.organization_id   = pma.organization_id
  AND    ogi4.org_information_context = 'Provincial Information'
  AND    ogi4.org_information1 = p_juris;