APPS.PAY_EXA_BUS SQL Statements

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

Line: 20

    SELECT 1
    FROM   FND_TERRITORIES_VL ft
    WHERE  ft.territory_code = p_territory_code
    ;

Line: 26

    SELECT territory_code
    FROM   PAY_EXTERNAL_ACCOUNTS pea
    WHERE  pea.external_account_id = p_external_account_id
    ;

Line: 97

procedure insert_validate(
   p_rec               in pay_exa_shd.g_rec_type
  ,p_business_group_id in number
  ) is
  --
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 116

end insert_validate;

Line: 121

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

Line: 140

end update_validate;