APPS.HR_TEMPLATE_ITEMS_API dependencies on HR_TEMPLATE_ITEMS_B

Line 1369: ,hr_template_items_b hti

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:
1373: ---- Fix For Bug 6631115 Starts ------

Line 1379: FROM hr_template_items_b

1375: CURSOR cur_template_item
1376: IS
1377: SELECT template_item_id
1378: ,object_version_number
1379: FROM hr_template_items_b
1380: WHERE template_item_id = p_template_item_id;
1381:
1382: l_template_item_id number;
1383: l_object_version_number number;

Line 1617: ,hr_template_items_b hti

1613: IS
1614: SELECT required_override
1615: ,visible_override
1616: FROM hr_form_items_b hfi
1617: ,hr_template_items_b hti
1618: WHERE hfi.form_item_id = hti.form_item_id
1619: AND hti.template_item_id = p_template_item_id;
1620:
1621: l_temp number;

Line 1627: ,hr_template_items_b hti

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:
1631: l_proc varchar2(72) := g_package||'update_template_item';