APPS.OKL_SO_CREDIT_APP_WF dependencies on AR_CMGT_CREDIT_REQUESTS

Line 149: from ar_cmgt_credit_requests

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

Line 623: FROM ar_cmgt_credit_requests

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

Line 1114: FROM AR_CMGT_CREDIT_REQUESTS CCR

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

Line 1120: l_credit_req_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE;

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