DBA Data[Home] [Help]

APPS.OE_PC_CONSTRAINTS_ADMIN_PVT dependencies on OE_PC_VTMPLT_COLS

Line 126: FROM oe_pc_vtmplt_cols vc,

122: -- the database object name to the FROM cursor.
123: CURSOR C_VTMPLTCOLS IS
124: SELECT vc.column_name, attr.data_type, vc.validation_op, vc.value_string
125: , decode(attr.state_attribute_flag,NULL,1,'Y',0,'N',1) state_attribute
126: FROM oe_pc_vtmplt_cols vc,
127: oe_pc_vtmplts vt,
128: oe_pc_attributes_v attr
129: WHERE vc.validation_tmplt_id = p_validation_tmplt_id
130: AND vc.validation_tmplt_id = vt.validation_tmplt_id

Line 322: FROM oe_pc_vtmplt_cols vc,

318: -- the database object name to the FROM cursor.
319: CURSOR C_VTMPLTCOLS IS
320: SELECT vc.column_name, attr.data_type, vc.validation_op, vc.value_string
321: , decode(attr.state_attribute_flag,NULL,1,'Y',0,'N',1) state_attribute
322: FROM oe_pc_vtmplt_cols vc,
323: oe_pc_vtmplts vt,
324: oe_pc_attributes_v attr
325: WHERE vc.validation_tmplt_id = p_validation_tmplt_id
326: AND vc.validation_tmplt_id = vt.validation_tmplt_id