APPS.OCM_CREDIT_REQ_WITHDRAW_PUB dependencies on AR_CMGT_CREDIT_REQUESTS

Line 46: FROM ar_cmgt_credit_requests

42: -- validate whether the credit request is valid or not
43: BEGIN
44: SELECT 'X'
45: INTO l_status
46: FROM ar_cmgt_credit_requests
47: WHERE credit_request_id = p_credit_request_id
48: AND status NOT IN ('WITHDRAW', 'PROCESSED');
49:
50: EXCEPTION

Line 83: UPDATE ar_cmgt_credit_requests

79: return;
80: END;
81:
82: -- Now update the status of credit request and case folder
83: UPDATE ar_cmgt_credit_requests
84: SET status = 'WITHDRAW'
85: WHERE credit_request_id = p_credit_request_id;
86:
87: UPDATE ar_cmgt_case_folders