APPS.JTF_BRM_UTILITY_PVT dependencies on WF_ACTIVITY_ATTRIBUTES_VL

Line 113: FROM wf_activity_attributes_vl wf1

109: ( b_wf_item_type IN VARCHAR2
110: , b_wf_process_name IN VARCHAR2
111: , b_wf_attribute_name IN VARCHAR2
112: )IS SELECT wf1.text_default attribute_value
113: FROM wf_activity_attributes_vl wf1
114: WHERE wf1.activity_version = (SELECT max(wf2.activity_version)
115: FROM wf_activity_attributes_vl wf2
116: WHERE wf2.activity_item_type = wf1.activity_item_type
117: AND wf2.activity_name = wf1.activity_name

Line 115: FROM wf_activity_attributes_vl wf2

111: , b_wf_attribute_name IN VARCHAR2
112: )IS SELECT wf1.text_default attribute_value
113: FROM wf_activity_attributes_vl wf1
114: WHERE wf1.activity_version = (SELECT max(wf2.activity_version)
115: FROM wf_activity_attributes_vl wf2
116: WHERE wf2.activity_item_type = wf1.activity_item_type
117: AND wf2.activity_name = wf1.activity_name
118: )
119: AND wf1.activity_item_type = b_wf_item_type

Line 218: FROM wf_activity_attributes_vl wf1

214: , b_wf_process_name IN VARCHAR2
215: , b_wf_attribute_name IN VARCHAR2
216: )IS SELECT wf1.text_default attribute_value
217: , wlu.meaning attribute_meaning
218: FROM wf_activity_attributes_vl wf1
219: , wf_lookups wlu
220: WHERE wf1.activity_version = (SELECT max(wf2.activity_version)
221: FROM wf_activity_attributes_vl wf2
222: WHERE wf2.activity_item_type = wf1.activity_item_type

Line 221: FROM wf_activity_attributes_vl wf2

217: , wlu.meaning attribute_meaning
218: FROM wf_activity_attributes_vl wf1
219: , wf_lookups wlu
220: WHERE wf1.activity_version = (SELECT max(wf2.activity_version)
221: FROM wf_activity_attributes_vl wf2
222: WHERE wf2.activity_item_type = wf1.activity_item_type
223: AND wf2.activity_name = wf1.activity_name
224: )
225: AND wf1.activity_item_type = b_wf_item_type