DBA Data[Home] [Help]

APPS.HR_ITEM_PROPERTIES_BSI dependencies on HR_ITEM_PROPERTIES_TL

Line 1180: FROM hr_item_properties_tl itptl

1176: ,DECODE(p_information_prompt,hr_api.g_varchar2,itptl.information_prompt,p_information_prompt) information_prompt
1177: ,DECODE(p_label,hr_api.g_varchar2,itptl.label,p_label) label
1178: ,DECODE(p_prompt_text,hr_api.g_varchar2,itptl.prompt_text,p_prompt_text) prompt_text
1179: ,DECODE(p_tooltip_text,hr_api.g_varchar2,itptl.tooltip_text,p_tooltip_text) tooltip_text
1180: FROM hr_item_properties_tl itptl
1181: ,hr_item_properties_b itp
1182: WHERE itptl.item_property_id = itp.item_property_id
1183: AND itp.form_item_id = p_form_item_id
1184: GROUP BY itptl.source_lang

Line 1682: FROM hr_item_properties_tl itptl

1678: ,DECODE(p_information_prompt,hr_api.g_varchar2,itptl.information_prompt,p_information_prompt) information_prompt
1679: ,DECODE(p_label,hr_api.g_varchar2,itptl.label,p_label) label
1680: ,DECODE(p_prompt_text,hr_api.g_varchar2,itptl.prompt_text,p_prompt_text) prompt_text
1681: ,DECODE(p_tooltip_text,hr_api.g_varchar2,itptl.tooltip_text,p_tooltip_text) tooltip_text
1682: FROM hr_item_properties_tl itptl
1683: ,hr_item_properties_b itp
1684: WHERE itptl.item_property_id = itp.item_property_id
1685: AND itp.template_item_id = p_template_item_id
1686: GROUP BY itptl.source_lang

Line 2185: FROM hr_item_properties_tl itptl

2181: ,DECODE(p_information_prompt,hr_api.g_varchar2,itptl.information_prompt,p_information_prompt) information_prompt
2182: ,DECODE(p_label,hr_api.g_varchar2,itptl.label,p_label) label
2183: ,DECODE(p_prompt_text,hr_api.g_varchar2,itptl.prompt_text,p_prompt_text) prompt_text
2184: ,DECODE(p_tooltip_text,hr_api.g_varchar2,itptl.tooltip_text,p_tooltip_text) tooltip_text
2185: FROM hr_item_properties_tl itptl
2186: ,hr_item_properties_b itp
2187: WHERE itptl.item_property_id = itp.item_property_id
2188: AND itp.template_item_id = p_template_item_id_from
2189: GROUP BY itptl.source_lang

Line 2693: FROM hr_item_properties_tl itptl

2689: ,DECODE(p_information_prompt,hr_api.g_varchar2,itptl.information_prompt,p_information_prompt) information_prompt
2690: ,DECODE(p_label,hr_api.g_varchar2,itptl.label,p_label) label
2691: ,DECODE(p_prompt_text,hr_api.g_varchar2,itptl.prompt_text,p_prompt_text) prompt_text
2692: ,DECODE(p_tooltip_text,hr_api.g_varchar2,itptl.tooltip_text,p_tooltip_text) tooltip_text
2693: FROM hr_item_properties_tl itptl
2694: ,hr_item_properties_b itp
2695: WHERE itptl.item_property_id = itp.item_property_id
2696: AND itp.template_item_context_id = p_template_item_context_id_frm
2697: GROUP BY itptl.source_lang