DBA Data[Home] [Help]

APPS.PAY_EXA_BUS dependencies on PAY_EXTERNAL_ACCOUNTS

Line 27: FROM PAY_EXTERNAL_ACCOUNTS pea

23: ;
24: --
25: cursor csr_territory_code is
26: SELECT territory_code
27: FROM PAY_EXTERNAL_ACCOUNTS pea
28: WHERE pea.external_account_id = p_external_account_id
29: ;
30: --
31: l_proc varchar2(72) := g_package||'chk_territory_code';

Line 34: l_territory_code pay_external_accounts.territory_code%type;

30: --
31: l_proc varchar2(72) := g_package||'chk_territory_code';
32: -- stub - l_api_updating is redundant
33: l_api_updating boolean;
34: l_territory_code pay_external_accounts.territory_code%type;
35: l_dummy number;
36: --
37: begin
38: hr_utility.set_location('Entering:'||l_proc, 5);