APPS.PQP_HROSS_INTEGRATION dependencies on DUAL

Line 3818: -- FROM dual

3814: -- -- Cursor to check if Address was End Dated or Updated
3815: -- CURSOR csr_chk_add_end_dated (c_batch_id IN Number
3816: -- ,c_link_value IN Number) IS
3817: -- SELECT 'END DATED'
3818: -- FROM dual
3819: -- WHERE
3820: -- 'UPDATE_PERSON_ADDRESS' IN
3821: -- (SELECT module_name
3822: -- FROM hr_pump_batch_lines hpbl, hr_api_modules ham

Line 6727: FROM dual;

6723: hr_utility.set_location('Entering: ' || l_proc_name, 10);
6724:
6725: SELECT hr_pump_batch_headers_s.nextval
6726: INTO p_batch_process_id
6727: FROM dual;
6728: p_batch_process_name := 'HROSS Batch Process ' || p_batch_process_id;
6729:
6730: OPEN csr_get_bg_name(Fnd_Profile.VALUE('PER_BUSINESS_GROUP_ID'));
6731: FETCH csr_get_bg_name INTO l_bg_name;