APPS.PAY_US_GEO_UPD_PKG dependencies on DUAL

Line 281: from dual;

277:
278: hr_utility.set_location('geocode_action_creation',4);
279: select pay_assignment_actions_s.nextval
280: into lockingactid
281: from dual;
282:
283: -- insert the action record.
284:
285: hr_nonrun_asact.insact(lockingactid => lockingactid,

Line 319: from dual;

315:
316: hr_utility.set_location('gocode_action_creation',7);
317: select pay_assignment_actions_s.nextval
318: into lockingactid
319: from dual;
320: --
321:
322: hr_nonrun_asact.insact(lockingactid => lockingactid,
323: Object_id => l_payact_id,

Line 478: select 'x' from dual

474:
475: -- Bug 3354053 -- Changed the cursor query to remove the FTS from pay_us_geo_update.
476: Cursor c_geo_upd (p_patch_id in number,
477: p_patch_status in varchar2) is
478: select 'x' from dual
479: where exists(select 'x' from pay_us_geo_update
480: where id = p_patch_id
481: and status = p_patch_status
482: and rownum < 2);

Line 2723: FROM dual

2719: BEGIN
2720:
2721: SELECT 'Y'
2722: INTO lv_update_prr
2723: FROM dual
2724: WHERE EXISTS (SELECT 0
2725: FROM pay_us_city_tax_info_f
2726: WHERE jurisdiction_code = main_old_juri_code)
2727: OR EXISTS (SELECT 0

Line 3572: FROM dual

3568: -- Bug 3319878 -- Changed the query to remove FTS from PAY_US_GEO_UPDATE
3569:
3570: CURSOR chk_last_api(p_geo_phase_id NUMBER, p_mode VARCHAR2) IS
3571: SELECT 'Y'
3572: FROM dual
3573: WHERE exists (SELECT /*+index(pugu PAY_US_GEO_UPDATE_N2) */ 'Y'
3574: FROM PAY_US_GEO_UPDATE pugu
3575: WHERE pugu.id = p_geo_phase_id
3576: AND pugu.process_mode = p_mode