APPS.HR_TEMPLATE_ITEMS_API dependencies on HR_SOURCE_FORM_TEMPLATES

Line 645: FROM hr_source_form_templates hsf

641: --
642: CURSOR cur_api_val
643: IS
644: SELECT source_form_template_id
645: FROM hr_source_form_templates hsf
646: WHERE hsf.form_template_id_to = p_form_template_id;
647: --
648: -- dummy local vars
649: --

Line 940: FROM hr_source_form_templates hsf

936:
937: CURSOR cur_api_val
938: IS
939: SELECT source_form_template_id
940: FROM hr_source_form_templates hsf
941: WHERE hsf.form_template_id_to = p_form_template_id;
942:
943: l_proc varchar2(72) := g_package||'create_template_item';
944: l_object_version_number number;

Line 1368: FROM hr_source_form_templates hsf

1364:
1365: CURSOR cur_api_val
1366: IS
1367: SELECT source_form_template_id
1368: FROM hr_source_form_templates hsf
1369: ,hr_template_items_b hti
1370: WHERE hsf.form_template_id_to = hti.form_template_id
1371: AND hti.template_item_id = p_template_item_id;
1372:

Line 1626: FROM hr_source_form_templates hsf

1622:
1623: CURSOR cur_api_val
1624: IS
1625: SELECT source_form_template_id
1626: FROM hr_source_form_templates hsf
1627: ,hr_template_items_b hti
1628: WHERE hsf.form_template_id_to = hti.form_template_id
1629: AND hti.template_item_id = p_template_item_id;
1630: