APPS.ASO_DEPENDENCY_UTIL dependencies on AK_OBJECT_ATTRIBUTES

Line 625: FROM oe_ak_obj_attr_ext a, ASO_DEPENDENCY_MAPPINGS b, ak_object_attributes c

621: l_dependent_code VARCHAR2(30);
622:
623: CURSOR c_trigger_attribute IS
624: SELECT DISTINCT a.attribute_code, a.attribute_id, c.column_name
625: FROM oe_ak_obj_attr_ext a, ASO_DEPENDENCY_MAPPINGS b, ak_object_attributes c
626: WHERE b.TRIGGER_ATTRIBUTE_ID = a.attribute_id
627: AND a.attribute_application_id = G_APPLICATION_ID
628: AND a.database_object_name = p_database_object_name
629: AND b.enabled_flag = 'Y'

Line 636: FROM oe_ak_obj_attr_ext a, ASO_DEPENDENCY_MAPPINGS b, ak_object_attributes c

632: AND a.attribute_application_id = c.attribute_application_id;
633:
634: CURSOR c_all_trigger_attribute IS
635: SELECT DISTINCT a.attribute_code, a.attribute_id, c.column_name
636: FROM oe_ak_obj_attr_ext a, ASO_DEPENDENCY_MAPPINGS b, ak_object_attributes c
637: WHERE b.TRIGGER_ATTRIBUTE_ID = a.attribute_id
638: AND a.attribute_application_id = G_APPLICATION_ID
639: AND a.database_object_name = p_database_object_name
640: AND a.database_object_name = c.database_object_name

Line 661: FROM ak_object_attributes

657: WHERE attribute_id = lc_attribute_id;
658:
659: CURSOR c_attribute_column_name(lc_attribute_code VARCHAR2) IS
660: SELECT column_name
661: FROM ak_object_attributes
662: WHERE database_object_name = p_database_object_name
663: AND attribute_code = lc_attribute_code;
664:
665: CURSOR c_attributes IS

Line 671: FROM oe_ak_obj_attr_ext a, ak_object_attributes b, ak_attributes c

667: DECODE(data_type, 'NUMBER', 'FND_API.G_MISS_NUM',
668: 'VARCHAR2', 'FND_API.G_MISS_CHAR',
669: 'DATE', 'FND_API.G_MISS_DATE',
670: 'FND_API.G_MISS_CHAR') miss_str
671: FROM oe_ak_obj_attr_ext a, ak_object_attributes b, ak_attributes c
672: WHERE a.attribute_application_id = G_APPLICATION_ID
673: AND a.database_object_name = p_database_object_name
674: AND a.database_object_name = b.database_object_name
675: AND a.attribute_application_id = b.attribute_application_id