APPS.PAY_PMA_BUS SQL Statements

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

Line: 111

    select null
    from   hr_all_organization_units a
    where  a.organization_id = p_organization_id;

Line: 116

    select null
    from   hr_organization_information ogi
    where  ogi.organization_id         = p_org_id
    and    ogi.org_information1        = 'CA_PMED'
    and    ogi.org_information_context = 'CLASS'
    and    ogi.org_information2        = 'Y';

Line: 211

  SELECT 1
  FROM   pay_ca_pmed_accounts pma
  WHERE  pma.organization_id = p_org_id
  AND    pma.account_number  = p_ac_num;

Line: 286

Procedure insert_validate(p_rec in pay_pma_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 316

End insert_validate;

Line: 321

Procedure update_validate(p_rec in pay_pma_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 351

End update_validate;

Line: 356

Procedure delete_validate(p_rec in pay_pma_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 366

End delete_validate;

Line: 379

    select a.legislation_code
    from   per_business_groups a,
           pay_ca_pmed_accounts b
    where b.source_id      = p_source_id
    and   a.business_group_id = b.business_group_id;