APPS.PER_HRTCA_MERGE dependencies on DUAL

Line 1891: from sys.dual;

1887: */
1888: hr_utility.set_location(l_proc,30);
1889: select hz_purge_batches_s.nextval
1890: into l_batchid
1891: from sys.dual;
1892:
1893: hr_utility.set_location(l_proc,40);
1894: insert into hz_purge_batches (batch_id,
1895: batch_name,

Line 3205: select 1 into l_dummy from dual;

3201: -- after call to update_tca_person, and raises NO_DATA_FOUND
3202: -- if true. This update statement is causing PER_CONTACT_RELATIONSHIPS
3203: -- to fail - so, force a dummy query to reset SQL%NOTFOUND here
3204: if (SQL%NOTFOUND) then
3205: select 1 into l_dummy from dual;
3206: end if;
3207: --
3208: --Modified Created by Module Code to 'HR API'
3209: fnd_profile.put('HZ_CREATED_BY_MODULE','HR API');

Line 3229: select 1 into l_dummy from dual;

3225: -- being true, causing PER_CONTACT_RELATIONSHIPS
3226: -- to fail erroneously - so, force a dummy query
3227: -- to reset SQL%NOTFOUND here
3228: if (SQL%NOTFOUND) then
3229: select 1 into l_dummy from dual;
3230: end if;
3231: --
3232: create_update_contact_point(p_rec => p_rec);
3233: --