DBA Data[Home] [Help]

APPS.RRS_ATTR_PANE dependencies on RRS_ATTR_PAGE_SETTINGS

Line 269: FROM RRS_ATTR_PAGE_SETTINGS

265: IF p_object2 IS NOT NULL AND p_classification_code2 IS NOT NULL THEN
266: SELECT ATTRIBUTE_PAGE_ID
267: BULK COLLECT
268: INTO l_page_id_array
269: FROM RRS_ATTR_PAGE_SETTINGS
270: WHERE WHERE_USED = p_where_used
271: AND OBJECT_TYPE = p_object_type
272: AND CATEGORIZATION_OBJECT1 = p_object1
273: AND CLASSIFICATION_CODE1 = p_classification_code1

Line 281: FROM RRS_ATTR_PAGE_SETTINGS

277: ELSIF p_object2 IS NULL AND p_classification_code2 IS NULL THEN
278: SELECT ATTRIBUTE_PAGE_ID
279: BULK COLLECT
280: INTO l_page_id_array
281: FROM RRS_ATTR_PAGE_SETTINGS
282: WHERE WHERE_USED = p_where_used
283: AND OBJECT_TYPE = p_object_type
284: AND CATEGORIZATION_OBJECT1 = p_object1
285: AND CLASSIFICATION_CODE1 = p_classification_code1

Line 293: FROM RRS_ATTR_PAGE_SETTINGS

289: ELSIF p_classification_code2 IS NULL THEN
290: SELECT ATTRIBUTE_PAGE_ID
291: BULK COLLECT
292: INTO l_page_id_array
293: FROM RRS_ATTR_PAGE_SETTINGS
294: WHERE WHERE_USED = p_where_used
295: AND OBJECT_TYPE = p_object_type
296: AND CATEGORIZATION_OBJECT1 = p_object1
297: AND CLASSIFICATION_CODE1 = p_classification_code1