DBA Data[Home] [Help]

APPS.PAY_GB_EPS_13 dependencies on FND_PROFILE

Line 317: fnd_profile_option_values fpov,fnd_profile_options fpo

313: l_proc varchar2(72) := g_package||'profile_option_value';
314:
315: /*cursor csr_get_profile is
316: select PROFILE_OPTION_VALUE from
317: fnd_profile_option_values fpov,fnd_profile_options fpo
318: where fpov.PROFILE_OPTION_ID = fpo.PROFILE_OPTION_ID
319: and fpo.PROFILE_OPTION_NAME = 'GB_EPS_APPROVAL';
320: */
321: BEGIN

Line 330: fnd_profile.get('GB_EPS_APPROVAL',p_return_status);

326: open csr_get_profile;
327: fetch csr_get_profile into p_return_status;
328: close csr_get_profile;*/
329:
330: fnd_profile.get('GB_EPS_APPROVAL',p_return_status);
331:
332: if p_return_status is null then
333: p_return_status := 'Y';
334: end if;