DBA Data[Home] [Help]

APPS.PJI_PMV_UTLZ dependencies on DUAL

Line 388: from dual;

384: */
385: BEGIN
386: SELECT fnd_profile.value('PA_ORG_UTIL_DEF_CALC_METHOD')
387: INTO l_denominator
388: from dual;
389:
390: EXCEPTION WHEN NO_DATA_FOUND THEN
391: l_denominator := 'CAPACITY';
392: END;

Line 1946: from dual;

1942: */
1943: BEGIN
1944: SELECT fnd_profile.value('PA_ORG_UTIL_DEF_CALC_METHOD')
1945: INTO l_denominator
1946: from dual;
1947:
1948: EXCEPTION WHEN NO_DATA_FOUND THEN
1949: l_denominator := 'CAPACITY';
1950: END;

Line 2175: from dual;

2171: */
2172: BEGIN
2173: SELECT fnd_profile.value('PA_ORG_UTIL_DEF_CALC_METHOD')
2174: INTO l_denominator
2175: from dual;
2176:
2177: EXCEPTION WHEN NO_DATA_FOUND THEN
2178: l_denominator := 'CAPACITY';
2179: END;

Line 3566: from dual;

3562: */
3563: BEGIN
3564: SELECT fnd_profile.value('PA_ORG_UTIL_DEF_CALC_METHOD')
3565: INTO l_denominator
3566: from dual;
3567:
3568: EXCEPTION WHEN NO_DATA_FOUND THEN
3569: l_denominator := 'CAPACITY';
3570: END;

Line 5809: from dual;

5805: */
5806: BEGIN
5807: SELECT fnd_profile.value('PA_ORG_UTIL_DEF_CALC_METHOD')
5808: INTO l_util_percent_denom_prof
5809: from dual;
5810:
5811: EXCEPTION WHEN NO_DATA_FOUND THEN
5812: l_util_percent_denom_prof := l_dft_util_percent_denom_prof;
5813: END;

Line 6446: from dual;

6442: */
6443: BEGIN
6444: SELECT fnd_profile.value('PA_ORG_UTIL_DEF_CALC_METHOD')
6445: INTO l_util_percent_denom_prof
6446: from dual;
6447:
6448: EXCEPTION WHEN NO_DATA_FOUND THEN
6449: l_util_percent_denom_prof := l_dft_util_percent_denom_prof;
6450: END;

Line 7135: from dual;

7131: */
7132: BEGIN
7133: SELECT fnd_profile.value('PA_ORG_UTIL_DEF_CALC_METHOD')
7134: INTO l_util_percent_denom_prof
7135: from dual;
7136:
7137: EXCEPTION WHEN NO_DATA_FOUND THEN
7138: l_util_percent_denom_prof := l_dft_util_percent_denom_prof;
7139: END;