APPS.CS_COST_DETAILS_PVT dependencies on CS_ESTIMATE_DETAILS

Line 235: FROM CS_ESTIMATE_DETAILS

231: x_return_status OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
232:
233: CURSOR c_estimate_detail_id IS
234: SELECT 1
235: FROM CS_ESTIMATE_DETAILS
236: WHERE estimate_detail_id = p_estimate_detail_id;
237:
238: lv_exists_flag VARCHAR2(1) := 'N';
239: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'is_estimate_detail_id_valid';

Line 1140: FROM CS_ESTIMATE_DETAILS

1136: x_source_id ,
1137: x_source_code ,
1138: x_org_id ,
1139: x_txn_inv_org
1140: FROM CS_ESTIMATE_DETAILS
1141: WHERE ESTIMATE_DETAIL_ID = p_estimate_detail_id
1142: FOR UPDATE OF ESTIMATE_DETAIL_ID NOWAIT ;
1143:
1144: EXCEPTION

Line 1266: FROM CS_cost_details csd,cs_estimate_details ced

1262: x_return_status := FND_API.G_RET_STS_SUCCESS;
1263:
1264: SELECT ced.estimate_detail_id
1265: INTO l_charge_exist
1266: FROM CS_cost_details csd,cs_estimate_details ced
1267: WHERE csd.cost_id =p_cost_id
1268: AND ced.estimate_Detail_id = csd.estimate_Detail_id
1269: FOR UPDATE OF COST_ID NOWAIT ;
1270:

Line 1542: --call get_charge_details to get the data from cs_estimate_details table

1538: FND_MSG_PUB.ADD;
1539: RAISE FND_API.G_EXC_ERROR;
1540: end if;
1541:
1542: --call get_charge_details to get the data from cs_estimate_details table
1543: get_charge_details
1544: (
1545: p_api_name => l_api_name_full,
1546: p_estimate_detail_id => l_cost_Rec.estimate_detail_id,