APPS.OKL_PARTY_MERGE_PUB dependencies on DUAL

Line 96: SELECT NVL(FND_PROFILE.VALUE('HZ_GENERATE_PARTY_SITE_NUMBER'), 'Y') INTO l_prof_value FROM DUAL;

92: p_party_site_rec.application_id := 540;
93:
94: --Obtain the profile value to find out whether site number is to be passed
95: --or not.
96: SELECT NVL(FND_PROFILE.VALUE('HZ_GENERATE_PARTY_SITE_NUMBER'), 'Y') INTO l_prof_value FROM DUAL;
97:
98: IF l_prof_value = 'Y'
99: THEN
100: p_party_site_rec.party_site_number := NULL;