DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_QUERY dependencies on HR_ITEM_PROPERTIES_TL

Line 61: , hr_item_properties_tl itptl

57: ,itptl.default_value
58: FROM hr_template_items_b tim
59: , hr_form_items_b fim
60: , hr_item_properties_b itpb
61: , hr_item_properties_tl itptl
62: WHERE fim.full_item_name = p_full_item_name
63: AND tim.form_item_id = fim.form_item_id
64: AND tim.form_template_id = p_form_template_id
65: AND itpb.template_item_id (+) = tim.template_item_id

Line 79: ,hr_item_properties_tl itptl

75: IS
76: SELECT itptl.default_value
77: FROM hr_item_contexts icx
78: ,hr_item_properties_b itpb
79: ,hr_item_properties_tl itptl
80: ,hr_template_item_contexts_b tic
81: WHERE icx.segment1 = p_emp_apl_flag
82: AND icx.item_context_id = tic.item_context_id
83: AND tic.context_type = 'QH_PER_TYPE'