APPS.HR_TEMPLATE_ITEM_CONTEXTS_API dependencies on HR_TEMPLATE_ITEMS

Line 105: ,hr_template_items tit

101: SELECT ttp2.template_tab_page_id
102: FROM hr_template_tab_pages ttp2
103: ,hr_template_canvases tcn
104: ,hr_template_windows twn
105: ,hr_template_items tit
106: ,hr_template_tab_pages ttp1
107: ,hr_template_item_context_pages tcp
108: WHERE ttp2.form_tab_page_id = ttp1.form_tab_page_id
109: AND ttp2.template_canvas_id = tcn.template_canvas_id

Line 122: ,hr_template_items_b hti

118: CURSOR cur_api_val
119: IS
120: SELECT source_form_template_id
121: FROM hr_source_form_templates hsf
122: ,hr_template_items_b hti
123: WHERE hsf.form_template_id_to = hti.form_template_id
124: AND hti.template_item_id = p_template_item_id;
125:
126: l_override_value_warning boolean;

Line 469: ,hr_template_items_b hti

465: IS
466: SELECT required_override
467: ,visible_override
468: FROM hr_form_items_b hfi
469: ,hr_template_items_b hti
470: WHERE hfi.form_item_id = hti.form_item_id
471: AND hti.template_item_id = p_template_item_id;
472:
473: l_temp number;

Line 479: ,hr_template_items_b hti

475: CURSOR cur_api_val
476: IS
477: SELECT source_form_template_id
478: FROM hr_source_form_templates hsf
479: ,hr_template_items_b hti
480: WHERE hsf.form_template_id_to = hti.form_template_id
481: AND hti.template_item_id = p_template_item_id;
482:
483: l_tic_id number;

Line 1012: ,hr_template_items_b hti

1008: CURSOR cur_api_val
1009: IS
1010: SELECT source_form_template_id
1011: FROM hr_source_form_templates hsf
1012: ,hr_template_items_b hti
1013: ,hr_template_item_contexts_b tic
1014: WHERE hsf.form_template_id_to = hti.form_template_id
1015: AND hti.template_item_id = tic.template_item_id
1016: AND tic.template_item_context_id = p_template_item_context_id;

Line 1264: ,hr_template_items_b hti

1260: IS
1261: SELECT required_override
1262: ,visible_override
1263: FROM hr_form_items_b hfi
1264: ,hr_template_items_b hti
1265: ,hr_template_item_contexts_b tic
1266: WHERE hfi.form_item_id = hti.form_item_id
1267: AND hti.template_item_id = tic.template_item_id
1268: AND tic.template_item_context_id = p_template_item_context_id;

Line 1276: ,hr_template_items_b hti

1272: CURSOR cur_api_val
1273: IS
1274: SELECT source_form_template_id
1275: FROM hr_source_form_templates hsf
1276: ,hr_template_items_b hti
1277: ,hr_template_item_contexts_b tic
1278: WHERE hsf.form_template_id_to = hti.form_template_id
1279: AND hti.template_item_id = tic.template_item_id
1280: AND tic.template_item_context_id = p_template_item_context_id;