APPS.PAY_GB_EPS dependencies on FND_PROFILE

Line 335: fnd_profile_option_values fpov,fnd_profile_options fpo

331: l_proc varchar2(72) := g_package||'profile_option_value';
332:
333: /*cursor csr_get_profile is
334: select PROFILE_OPTION_VALUE from
335: fnd_profile_option_values fpov,fnd_profile_options fpo
336: where fpov.PROFILE_OPTION_ID = fpo.PROFILE_OPTION_ID
337: and fpo.PROFILE_OPTION_NAME = 'GB_EPS_APPROVAL';
338: */
339: BEGIN

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

344: open csr_get_profile;
345: fetch csr_get_profile into p_return_status;
346: close csr_get_profile;*/
347:
348: fnd_profile.get('GB_EPS_APPROVAL',p_return_status);
349:
350: if p_return_status is null then
351: p_return_status := 'Y';
352: end if;