DBA Data[Home] [Help]

APPS.CSI_T_TXN_ATTRIBS_PVT dependencies on CSI_IEA_VALUES

Line 978: 'from csi_iea_values '||

974: ' active_start_date, active_end_date, context, attribute1, attribute2,'||
975: ' attribute3, attribute4, attribute5, attribute6, attribute7,'||
976: ' attribute8, attribute9, attribute10, attribute11, attribute12,'||
977: ' attribute13, attribute14, attribute15, object_version_number '||
978: 'from csi_iea_values '||
979: 'where instance_id = :instance_id';
980:
981: l_iea_cur_id := dbms_sql.open_cursor;
982:

Line 1581: FROM csi_iea_values

1577: CURSOR iea_values_cur (c_instance_id IN NUMBER,
1578: c_attrib_source_id IN NUMBER)
1579: IS
1580: SELECT attribute_value_id
1581: FROM csi_iea_values
1582: WHERE instance_id = c_instance_id
1583: AND attribute_id = c_attrib_source_id
1584: AND (active_end_date is NULL OR
1585: trunc(active_end_date) > l_sysdate) ;

Line 1705: x_source_table := 'CSI_IEA_VALUES' ;

1701: RAISE fnd_api.g_exc_error ;
1702: END IF ;
1703: IF l_attribute_value_id IS NOT NULL
1704: THEN
1705: x_source_table := 'CSI_IEA_VALUES' ;
1706: x_attribute_id := l_attribute_value_id ;
1707: ELSE
1708: x_source_table := 'CSI_I_EXTENDED_ATTRIBS' ;
1709: END IF ; --l_attribute_value_id