DBA Data[Home] [Help]

APPS.HR_TEMPLATE_ITEM_CONTEXTS_API dependencies on HR_SOURCE_FORM_TEMPLATES

Line 121: FROM hr_source_form_templates hsf

117:
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:

Line 478: FROM hr_source_form_templates hsf

474:
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:

Line 1011: FROM hr_source_form_templates hsf

1007:
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

Line 1275: FROM hr_source_form_templates hsf

1271:
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