APPS.HR_ITEM_PROPERTIES_BSI dependencies on HR_FORM_ITEMS_B

Line 44: ,hr_form_items_b fi2

40: )
41: IS
42: SELECT itp.item_property_id
43: FROM hr_item_properties_b itp
44: ,hr_form_items_b fi2
45: ,hr_form_items_b fi1
46: WHERE itp.form_item_id = fi2.form_item_id
47: AND fi2.application_id = fi1.application_id
48: AND fi2.form_id = fi1.form_id

Line 45: ,hr_form_items_b fi1

41: IS
42: SELECT itp.item_property_id
43: FROM hr_item_properties_b itp
44: ,hr_form_items_b fi2
45: ,hr_form_items_b fi1
46: WHERE itp.form_item_id = fi2.form_item_id
47: AND fi2.application_id = fi1.application_id
48: AND fi2.form_id = fi1.form_id
49: AND fi2.full_item_name = fi1.full_item_name

Line 60: ,hr_form_items_b fi2

56: IS
57: SELECT itp.item_property_id
58: FROM hr_item_properties_b itp
59: ,hr_template_items_b ti2
60: ,hr_form_items_b fi2
61: ,hr_form_items_b fi1
62: ,hr_template_items_b ti1
63: WHERE itp.template_item_id = ti2.template_item_id
64: AND ti2.form_template_id = ti1.form_template_id

Line 61: ,hr_form_items_b fi1

57: SELECT itp.item_property_id
58: FROM hr_item_properties_b itp
59: ,hr_template_items_b ti2
60: ,hr_form_items_b fi2
61: ,hr_form_items_b fi1
62: ,hr_template_items_b ti1
63: WHERE itp.template_item_id = ti2.template_item_id
64: AND ti2.form_template_id = ti1.form_template_id
65: AND ti2.form_item_id = fi2.form_item_id

Line 81: ,hr_form_items_b fi2

77: SELECT itp.item_property_id
78: FROM hr_item_properties_b itp
79: ,hr_template_item_contexts_b tc2
80: ,hr_template_items_b ti2
81: ,hr_form_items_b fi2
82: ,hr_form_items_b fi1
83: ,hr_template_items_b ti1
84: ,hr_template_item_contexts_b tc1
85: WHERE itp.template_item_context_id = tc2.template_item_context_id

Line 82: ,hr_form_items_b fi1

78: FROM hr_item_properties_b itp
79: ,hr_template_item_contexts_b tc2
80: ,hr_template_items_b ti2
81: ,hr_form_items_b fi2
82: ,hr_form_items_b fi1
83: ,hr_template_items_b ti1
84: ,hr_template_item_contexts_b tc1
85: WHERE itp.template_item_context_id = tc2.template_item_context_id
86: AND tc2.item_context_id = tc1.item_context_id

Line 1167: , hr_form_items_b hfi

1163: ,DECODE(p_information30,hr_api.g_varchar2,itp.information30,p_information30)
1164: ,DECODE(p_next_navigation_item_id,hr_api.g_number,itp.next_navigation_item_id,p_next_navigation_item_id)
1165: ,DECODE(p_previous_navigation_item_id,hr_api.g_number,itp.previous_navigation_item_id,p_previous_navigation_item_id)
1166: FROM hr_item_properties_b itp
1167: , hr_form_items_b hfi
1168: WHERE itp.form_item_id (+) = hfi.form_item_id
1169: AND hfi.form_item_id = p_form_item_id;
1170:
1171: CURSOR cur_item_tl