APPS.OKC_OUTCOME_INIT_PVT dependencies on FND_PROFILE

Line 4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

1: Package body OKC_OUTCOME_INIT_PVT AS
2: /* $Header: OKCROCEB.pls 120.1 2005/12/14 22:18:30 npalepu noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:
6: --
7: -- Package Variables
8: --

Line 55: FROM fnd_profile_options op,

51: l_contract_id NUMBER;
52:
53: CURSOR profile_cur1 IS
54: SELECT opval.profile_option_value profile_value
55: FROM fnd_profile_options op,
56: fnd_profile_option_values opval
57: WHERE op.profile_option_id = opval.profile_option_id
58: AND op.application_id = opval.application_id
59: AND op.profile_option_name = 'OKC_S_RECIPIENT';

Line 56: fnd_profile_option_values opval

52:
53: CURSOR profile_cur1 IS
54: SELECT opval.profile_option_value profile_value
55: FROM fnd_profile_options op,
56: fnd_profile_option_values opval
57: WHERE op.profile_option_id = opval.profile_option_id
58: AND op.application_id = opval.application_id
59: AND op.profile_option_name = 'OKC_S_RECIPIENT';
60: profile_rec1 profile_cur1%ROWTYPE;

Line 64: FROM fnd_profile_options op,

60: profile_rec1 profile_cur1%ROWTYPE;
61:
62: CURSOR profile_cur2 IS
63: SELECT opval.profile_option_value profile_value
64: FROM fnd_profile_options op,
65: fnd_profile_option_values opval
66: WHERE op.profile_option_id = opval.profile_option_id
67: AND op.application_id = opval.application_id
68: AND op.profile_option_name = 'OKC_E_RECIPIENT';

Line 65: fnd_profile_option_values opval

61:
62: CURSOR profile_cur2 IS
63: SELECT opval.profile_option_value profile_value
64: FROM fnd_profile_options op,
65: fnd_profile_option_values opval
66: WHERE op.profile_option_id = opval.profile_option_id
67: AND op.application_id = opval.application_id
68: AND op.profile_option_name = 'OKC_E_RECIPIENT';
69: profile_rec2 profile_cur2%ROWTYPE;