APPS.CSF_RESOURCE_ADDRESS_PVT dependencies on DUAL

Line 798: FROM dual;

794: -- If the profile "Generate Party Number" is No, then
795: -- TCA expects the caller to pass the party number.
796: IF fnd_profile.VALUE('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN
797: SELECT hz_party_number_s.NEXTVAL INTO l_person_rec.party_rec.party_number
798: FROM dual;
799: END IF;
800:
801: IF l_debug THEN
802: debug('Creating Party Record in HZ_PARTIES', l_api_name, fnd_log.level_statement);

Line 847: FROM dual;

843: -- If the profile "Generate Party Number" is No, then
844: -- TCA expects the caller to pass the party number.
845: IF fnd_profile.VALUE('HZ_GENERATE_PARTY_SITE_NUMBER') = 'N' THEN
846: SELECT hz_party_site_number_s.NEXTVAL INTO l_party_site_rec.party_site_number
847: FROM dual;
848: END IF;
849:
850: IF l_debug THEN
851: debug('Creating Party Site Record in HZ_PARTY_SITES', l_api_name, fnd_log.level_statement);