DBA Data[Home] [Help]

APPS.HR_TEMPLATE_WINDOWS_API dependencies on DUAL

Line 41: SELECT 1 from dual where exists( --added line for 2832106

37: l_temp number;
38:
39: CURSOR cur_api_val
40: IS
41: SELECT 1 from dual where exists( --added line for 2832106
42: SELECT source_form_template_id
43: FROM hr_source_form_templates hsf
44: WHERE hsf.form_template_id_to = p_form_template_id);
45:

Line 262: SELECT 1 from dual where exists( --added line for 2832106, removed unnecessary joins

258: l_temp number;
259:
260: CURSOR cur_api_val
261: IS
262: SELECT 1 from dual where exists( --added line for 2832106, removed unnecessary joins
263: SELECT source_form_template_id
264: FROM hr_source_form_templates hsf
265: -- ,hr_template_windows_b htw
266: -- ,hr_template_canvases_b htc

Line 579: SELECT 1 from dual where exists( --added line for 2832106

575: l_temp number;
576:
577: CURSOR cur_api_val
578: IS
579: SELECT 1 from dual where exists( --added line for 2832106
580: SELECT source_form_template_id
581: FROM hr_source_form_templates hsf
582: ,hr_template_windows_b htw
583: WHERE hsf.form_template_id_to = htw.form_template_id

Line 782: SELECT 1 from dual where exists( --added line for 2832106, removed unnecessary joins

778: l_temp number;
779:
780: CURSOR cur_api_val
781: IS
782: SELECT 1 from dual where exists( --added line for 2832106, removed unnecessary joins
783: SELECT source_form_template_id
784: FROM hr_source_form_templates hsf
785: ,hr_template_windows_b htw
786: -- ,hr_template_canvases_b htc