APPS.AHL_PC_ASSOCIATION_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 5

	G_DML_UPDATE	CONSTANT	VARCHAR2(1)	:= 'U';

Line: 6

	G_DML_DELETE	CONSTANT	VARCHAR2(1)	:= 'D';

Line: 29

		select unit_config_header_id
		FROM ahl_unit_header_details_v
		where name = p_pc_unit_name;

Line: 33

                SELECT unit_config_header_id
                FROM   ahl_unit_config_headers
                WHERE  name = p_pc_unit_name;

Line: 65

		select inventory_item_id
		FROM mtl_system_items_kfv
		where concatenated_segments = p_pc_part_name;

Line: 190

				ELSIF (p_x_assos_tbl(i).operation_flag = G_DML_DELETE)
				THEN
					IF (p_x_assos_tbl(i).association_type_flag = G_UNIT)
					THEN
						IF p_module_type IS NULL OR p_module_type = 'JSP'
						THEN
							p_x_assos_tbl(i).unit_item_id := NULL;