APPS.OKL_SO_CREDIT_APP_WF dependencies on AR_CMGT_CF_RECOMMENDS

Line 343: FROM ar_cmgt_cf_recommends

339: SELECT
340: credit_recommendation
341: ,recommendation_value1
342: ,recommendation_value2
343: FROM ar_cmgt_cf_recommends
344: WHERE credit_request_id = b_credit_request_id;
345:
346: begin
347: --

Line 652: FROM ar_cmgt_cf_recommends

648: CURSOR c_recommendation (b_request_id IN NUMBER) IS
649: SELECT credit_recommendation,
650: recommendation_value1,
651: recommendation_value2
652: FROM ar_cmgt_cf_recommends
653: WHERE credit_request_id = b_request_id ;
654:
655: CURSOR get_resource_id(b_user_id NUMBER) IS
656: SELECT resource_id

Line 1132: FROM ar_cmgt_cf_recommends

1128:
1129: CURSOR credit_req_sts_csr(p_credit_request_id IN NUMBER)
1130: IS
1131: SELECT credit_recommendation, status
1132: FROM ar_cmgt_cf_recommends
1133: WHERE credit_request_id = p_credit_request_id
1134: AND credit_recommendation IN ('REJECT','APPROVE');
1135:
1136: l_request_status ar_cmgt_cf_recommends.status%TYPE;

Line 1136: l_request_status ar_cmgt_cf_recommends.status%TYPE;

1132: FROM ar_cmgt_cf_recommends
1133: WHERE credit_request_id = p_credit_request_id
1134: AND credit_recommendation IN ('REJECT','APPROVE');
1135:
1136: l_request_status ar_cmgt_cf_recommends.status%TYPE;
1137: l_cr_recom ar_cmgt_cf_recommends.credit_recommendation%TYPE;
1138:
1139: BEGIN
1140: l_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1137: l_cr_recom ar_cmgt_cf_recommends.credit_recommendation%TYPE;

1133: WHERE credit_request_id = p_credit_request_id
1134: AND credit_recommendation IN ('REJECT','APPROVE');
1135:
1136: l_request_status ar_cmgt_cf_recommends.status%TYPE;
1137: l_cr_recom ar_cmgt_cf_recommends.credit_recommendation%TYPE;
1138:
1139: BEGIN
1140: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1141: L_MODULE := 'OKL.PLSQL.OKL_SO_CREDIT_APP_WF.UPDATE_STATUS';