APPS.CS_CONTRACTS_PUB dependencies on CS_CONTRACT_STATUSES

Line 981: p_inv_flag CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE;

977: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
978: l_contract_rec CS_CONTRACT_PVT.Contract_Val_Rec_Type;
979: p_old_status_id CS_CONTRACTS.CONTRACT_STATUS_ID%TYPE;
980: p_new_status_id CS_CONTRACTS.CONTRACT_STATUS_ID%TYPE;
981: p_inv_flag CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE;
982: BEGIN
983: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
984: G_PKG_NAME,
985: l_api_version,

Line 1091: FROM CS_CONTRACT_STATUSES

1087: WHERE contract_id = l_contract_rec.contract_id;
1088:
1089: SELECT eligible_for_invoicing
1090: INTO p_inv_flag
1091: FROM CS_CONTRACT_STATUSES
1092: WHERE contract_status_id = p_new_status_id;
1093:
1094: --- Call update service if status changes
1095: IF l_contract_rec.contract_status_id <> TAPI_DEV_KIT.G_MISS_NUM and