APPS.CSM_HZ_LOCATION_PKG dependencies on DUAL

Line 40: UNION ALL SELECT 'GENERIC' FROM DUAL;

36:
37: CURSOR c_style IS
38: select address_style from fnd_territories_vl where address_style is not null
39: and TERRITORY_CODE=l_country
40: UNION ALL SELECT 'GENERIC' FROM DUAL;
41:
42: BEGIN
43:
44: SELECT user_id,responsibility_id, app_id ,org_id,resource_id

Line 191: FROM dual;

187: -- If the profile "Generate Party Number" is No, then
188: -- TCA expects the caller to pass the party number.
189: IF fnd_profile.VALUE('HZ_GENERATE_PARTY_SITE_NUMBER') = 'N' THEN
190: SELECT hz_party_site_number_s.NEXTVAL INTO l_party_site_rec.party_site_number
191: FROM dual;
192: END IF;
193:
194: hz_party_site_v2pub.create_party_site(
195: p_init_msg_list => fnd_api.g_false