APPS.CSF_RESOURCE_ADDRESS_PVT dependencies on DUAL

Line 937: FROM dual;

933: -- If the profile "Generate Party Number" is No, then
934: -- TCA expects the caller to pass the party number.
935: IF fnd_profile.VALUE('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN
936: SELECT hz_party_number_s.NEXTVAL INTO l_person_rec.party_rec.party_number
937: FROM dual;
938: END IF;
939:
940: IF l_debug THEN
941: debug('Creating Party Record in HZ_PARTIES', l_api_name, fnd_log.level_statement);

Line 986: FROM dual;

982: -- If the profile "Generate Party Number" is No, then
983: -- TCA expects the caller to pass the party number.
984: IF fnd_profile.VALUE('HZ_GENERATE_PARTY_SITE_NUMBER') = 'N' THEN
985: SELECT hz_party_site_number_s.NEXTVAL INTO l_party_site_rec.party_site_number
986: FROM dual;
987: END IF;
988:
989: IF l_debug THEN
990: debug('Creating Party Site Record in HZ_PARTY_SITES', l_api_name, fnd_log.level_statement);

Line 1452: FROM dual;

1448: -- If the profile "Generate Party Number" is No, then
1449: -- TCA expects the caller to pass the party number.
1450: IF fnd_profile.VALUE('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN
1451: SELECT hz_party_number_s.NEXTVAL INTO l_person_rec.party_rec.party_number
1452: FROM dual;
1453: END IF;
1454:
1455: IF l_debug THEN
1456: debug('Creating Party Record in HZ_PARTIES', l_api_name, fnd_log.level_statement);

Line 1501: FROM dual;

1497: -- If the profile "Generate Party Number" is No, then
1498: -- TCA expects the caller to pass the party number.
1499: IF fnd_profile.VALUE('HZ_GENERATE_PARTY_SITE_NUMBER') = 'N' THEN
1500: SELECT hz_party_site_number_s.NEXTVAL INTO l_party_site_rec.party_site_number
1501: FROM dual;
1502: END IF;
1503:
1504: IF l_debug THEN
1505: debug('Creating Party Site Record in HZ_PARTY_SITES', l_api_name, fnd_log.level_statement);