APPS.HR_ITEM_PROPERTIES_PKG dependencies on HR_TEMPLATE_ITEMS_B

Line 106: ,HR_TEMPLATE_ITEMS_B tim

102: l_original csr_original%rowtype;
103: cursor csr_copies is
104: select itp.item_property_id
105: from HR_ITEM_PROPERTIES_B itp
106: ,HR_TEMPLATE_ITEMS_B tim
107: ,HR_TEMPLATE_ITEMS_B tio
108: where itp.TEMPLATE_ITEM_ID = tim.TEMPLATE_ITEM_ID
109: and tim.FORM_TEMPLATE_ID in (select sft.FORM_TEMPLATE_ID_TO
110: from HR_SOURCE_FORM_TEMPLATES sft

Line 107: ,HR_TEMPLATE_ITEMS_B tio

103: cursor csr_copies is
104: select itp.item_property_id
105: from HR_ITEM_PROPERTIES_B itp
106: ,HR_TEMPLATE_ITEMS_B tim
107: ,HR_TEMPLATE_ITEMS_B tio
108: where itp.TEMPLATE_ITEM_ID = tim.TEMPLATE_ITEM_ID
109: and tim.FORM_TEMPLATE_ID in (select sft.FORM_TEMPLATE_ID_TO
110: from HR_SOURCE_FORM_TEMPLATES sft
111: start with sft.FORM_TEMPLATE_ID_FROM = tio.FORM_TEMPLATE_ID

Line 1704: ,hr_template_items_b hti

1700:
1701: select hti.template_item_id
1702: into x_template_item_id
1703: from hr_form_templates_b hft
1704: ,hr_template_items_b hti
1705: where hti.form_item_id = x_form_item_id
1706: and hti.form_template_id = hft.form_template_id
1707: and hft.form_id = x_form_id
1708: and hft.application_id = x_application_id

Line 2191: ,hr_template_items_b hti

2187:
2188: select hti.template_item_id
2189: into x_template_item_id
2190: from hr_form_templates_b hft
2191: ,hr_template_items_b hti
2192: where hti.form_item_id = x_form_item_id
2193: and hti.form_template_id = hft.form_template_id
2194: and hft.form_id = x_form_id
2195: and hft.application_id = x_application_id

Line 2231: from hr_template_items_b hti

2227: END IF;
2228: --
2229: select hti.template_item_id
2230: into x_template_item_id
2231: from hr_template_items_b hti
2232: where hti.form_item_id = x_form_item_id
2233: and hti.form_template_id = g_form_template_id;
2234: --
2235:

Line 2479: ,hr_template_items_b hti

2475:
2476: select hti.template_item_id
2477: into x_template_item_id
2478: from hr_form_templates_b hft
2479: ,hr_template_items_b hti
2480: where hti.form_item_id = x_form_item_id
2481: and hti.form_template_id = hft.form_template_id
2482: and hft.form_id = x_form_id
2483: and hft.application_id = x_application_id

Line 2519: from hr_template_items_b hti

2515: END IF;
2516: --
2517: select hti.template_item_id
2518: into x_template_item_id
2519: from hr_template_items_b hti
2520: where hti.form_item_id = x_form_item_id
2521: and hti.form_template_id = g_form_template_id;
2522: --
2523: