APPS.PER_HRTCA_MERGE dependencies on DUAL

Line 1894: from sys.dual;

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

Line 3219: select 1 into l_dummy from dual;

3215: -- after call to update_tca_person, and raises NO_DATA_FOUND
3216: -- if true. This update statement is causing PER_CONTACT_RELATIONSHIPS
3217: -- to fail - so, force a dummy query to reset SQL%NOTFOUND here
3218: if (SQL%NOTFOUND) then
3219: select 1 into l_dummy from dual;
3220: end if;
3221: --
3222: --Modified Created by Module Code to 'HR API'
3223: fnd_profile.put('HZ_CREATED_BY_MODULE','HR API');

Line 3243: select 1 into l_dummy from dual;

3239: -- being true, causing PER_CONTACT_RELATIONSHIPS
3240: -- to fail erroneously - so, force a dummy query
3241: -- to reset SQL%NOTFOUND here
3242: if (SQL%NOTFOUND) then
3243: select 1 into l_dummy from dual;
3244: end if;
3245: --
3246: create_update_contact_point(p_party_id => p_rec.party_id,
3247: p_email_address=>p_rec.email_address);