APPS.OKC_CHANGE_CONTRACT_PVT dependencies on OKC_CHANGE_REQUESTS_V

Line 67: l_chgreq_date OKC_CHANGE_REQUESTS_V.DATETIME_REQUEST%TYPE;

63: Cursor cur_chg(chq_id number) IS
64: Select datetime_request
65: FROM OKC_CHANGE_REQUESTS_B where
66: ID=chq_id;
67: l_chgreq_date OKC_CHANGE_REQUESTS_V.DATETIME_REQUEST%TYPE;
68: --end san
69:
70: l_api_name CONSTANT VARCHAR2(30) := 'change_approval_start';
71: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 109: from okc_change_requests_v C,

105: NVL(C.USER_ID,OKC_API.G_MISS_NUM) AUTH_USER_ID,
106: U.USER_NAME AUTH_USERNAME,
107: C.AUTHORITY REQUESTOR,
108: C.SIGNATURE_REQUIRED_YN
109: from okc_change_requests_v C,
110: OKC_K_PROCESSES cpr,
111: OKC_K_HDR_AGREEDS_V K,
112: fnd_user_view U
113: where C.ID = p_change_request_id

Line 745: from okc_change_requests_v C,

741: select
742: substr(K.CONTRACT_NUMBER
743: ||K.CONTRACT_NUMBER_MODIFIER
744: ||C.NAME,1,240) KEY
745: from okc_change_requests_v C,
746: OKC_K_HDR_AGREEDS_V K
747: where C.ID = p_change_request_id
748: and K.ID = C.CHR_ID;
749: --

Line 818: from okc_change_requests_v C,

814: K.ID CONTRACT_ID,
815: substr(K.CONTRACT_NUMBER
816: ||K.CONTRACT_NUMBER_MODIFIER
817: ||C.NAME,1,240) KEY
818: from okc_change_requests_v C,
819: OKC_K_HDR_AGREEDS_V K
820: where C.ID = p_change_request_id
821: and K.ID = C.CHR_ID;
822: --