APPS.PA_MAPPING_PVT dependencies on PA_VALUE_MAP_DEFS

Line 57: FROM PA_VALUE_MAP_DEFS

53:
54: -- Get value map definition type.
55: SELECT value_map_def_type
56: INTO l_value_map_def_type
57: FROM PA_VALUE_MAP_DEFS
58: WHERE value_map_def_id = p_value_map_def_id;
59:
60: -- Name and Id validation.
61: v_1:= 1;

Line 116: -- Update record version number in header table PA_VALUE_MAP_DEFS.

112: END IF;
113: END LOOP;
114:
115: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
116: -- Update record version number in header table PA_VALUE_MAP_DEFS.
117: PA_VALUE_MAP_DEF_PKG.update_row(p_value_map_def_id => p_value_map_def_id,
118: p_record_version_number => p_record_version_number,
119: x_return_status => x_return_status,
120: x_msg_count => x_msg_count,

Line 218: FROM pa_value_maps map, pa_value_map_defs def

214: IS
215:
216: CURSOR c1 IS
217: SELECT dest_value, dest_value_pk1, dest_value_pk2, dest_value_pk3, dest_value_pk4, dest_value_pk5
218: FROM pa_value_maps map, pa_value_map_defs def
219: WHERE map.value_map_def_id = def.value_map_def_id
220: AND def.value_map_def_type = p_value_map_def_type
221: AND def.def_subtype = p_def_subtype
222: AND map.source_value = p_source_value