DBA Data[Home] [Help]

APPS.HR_ITEM_PROPERTIES_PKG dependencies on HR_SOURCE_FORM_TEMPLATES

Line 110: from HR_SOURCE_FORM_TEMPLATES sft

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
112: connect by sft.FORM_TEMPLATE_ID_FROM = prior sft.FORM_TEMPLATE_ID_TO)
113: and tim.FORM_ITEM_ID = tio.FORM_ITEM_ID
114: and tio.TEMPLATE_ITEM_ID = X_TEMPLATE_ITEM_ID;