APPS.OKL_SO_CREDIT_APP_WF dependencies on AR_CMGT_CF_RECOMMENDS

Line 346: FROM ar_cmgt_cf_recommends

342: SELECT
343: credit_recommendation
344: ,recommendation_value1
345: ,recommendation_value2
346: FROM ar_cmgt_cf_recommends
347: WHERE credit_request_id = b_credit_request_id;
348:
349: begin
350: --

Line 655: FROM ar_cmgt_cf_recommends

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

Line 1135: FROM ar_cmgt_cf_recommends

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

Line 1139: l_request_status ar_cmgt_cf_recommends.status%TYPE;

1135: FROM ar_cmgt_cf_recommends
1136: WHERE credit_request_id = p_credit_request_id
1137: AND credit_recommendation IN ('REJECT','APPROVE');
1138:
1139: l_request_status ar_cmgt_cf_recommends.status%TYPE;
1140: l_cr_recom ar_cmgt_cf_recommends.credit_recommendation%TYPE;
1141:
1142: --Bug 7140398 START
1143: CURSOR get_main_offer_csr(cp_lap_id NUMBER) IS

Line 1140: l_cr_recom ar_cmgt_cf_recommends.credit_recommendation%TYPE;

1136: WHERE credit_request_id = p_credit_request_id
1137: AND credit_recommendation IN ('REJECT','APPROVE');
1138:
1139: l_request_status ar_cmgt_cf_recommends.status%TYPE;
1140: l_cr_recom ar_cmgt_cf_recommends.credit_recommendation%TYPE;
1141:
1142: --Bug 7140398 START
1143: CURSOR get_main_offer_csr(cp_lap_id NUMBER) IS
1144: SELECT ID