APPS.OKL_SO_CREDIT_APP_WF dependencies on AR_CMGT_CREDIT_REQUESTS

Line 152: from ar_cmgt_credit_requests

148:
149: -- get the user who submitted the credit request
150: cursor c_submitted_by (b_credit_request_id IN NUMBER) IS
151: select source_user_id
152: from ar_cmgt_credit_requests
153: where credit_request_id = b_credit_request_id;
154:
155: begin
156: --

Line 626: FROM ar_cmgt_credit_requests

622: ,party_id
623: ,cust_account_id
624: ,site_use_id
625: ,application_date
626: FROM ar_cmgt_credit_requests
627: WHERE credit_request_id = b_credit_request_id;
628:
629: -- credit/contract relationship
630: CURSOR c_okl_credit_request (b_credit_request_id IN NUMBER) IS

Line 1117: FROM AR_CMGT_CREDIT_REQUESTS CCR

1113: , LAB.CREATED_BY
1114: , LAB.PROSPECT_ID
1115: , LAB.CUST_ACCT_ID
1116: , LAB.ORG_ID
1117: FROM AR_CMGT_CREDIT_REQUESTS CCR
1118: , OKL_LEASE_APPS_ALL_B LAB
1119: WHERE CCR.SOURCE_COLUMN3 = 'LEASEAPP'
1120: AND CCR.SOURCE_COLUMN1 = LAB.ID
1121: AND CCR.CREDIT_REQUEST_ID = cp_credit_req_id;

Line 1123: l_credit_req_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE;

1119: WHERE CCR.SOURCE_COLUMN3 = 'LEASEAPP'
1120: AND CCR.SOURCE_COLUMN1 = LAB.ID
1121: AND CCR.CREDIT_REQUEST_ID = cp_credit_req_id;
1122:
1123: l_credit_req_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE;
1124: l_lap_id OKL_LEASE_APPLICATIONS_B.ID%TYPE;
1125: l_created_by OKL_LEASE_APPLICATIONS_B.CREATED_BY%TYPE;
1126: -- Bug#4741121 - viselvar - Modified - Start
1127: l_parameter_list wf_parameter_list_t;