DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_QUERY dependencies on HR_ITEM_PROPERTIES_B

Line 60: , hr_item_properties_b itpb

56: SELECT tim.template_item_id
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

Line 78: ,hr_item_properties_b itpb

74: )
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