APPS.HZ_CREDIT_REQUEST_PVT dependencies on AR_CMGT_CREDIT_REQUESTS

Line 38: l_limit_currency AR_CMGT_CREDIT_REQUESTS.limit_currency%TYPE;

34: l_key VARCHAR2(240);
35: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type;
36: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
37: l_credit_check_rule_id NUMBER;
38: l_limit_currency AR_CMGT_CREDIT_REQUESTS.limit_currency%TYPE;
39: l_trx_amount NUMBER;
40: l_trx_currency AR_CMGT_CREDIT_REQUESTS.trx_currency%TYPE;
41: l_source_column1 NUMBER;
42: l_source_column2 NUMBER;

Line 40: l_trx_currency AR_CMGT_CREDIT_REQUESTS.trx_currency%TYPE;

36: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
37: l_credit_check_rule_id NUMBER;
38: l_limit_currency AR_CMGT_CREDIT_REQUESTS.limit_currency%TYPE;
39: l_trx_amount NUMBER;
40: l_trx_currency AR_CMGT_CREDIT_REQUESTS.trx_currency%TYPE;
41: l_source_column1 NUMBER;
42: l_source_column2 NUMBER;
43: l_source_column3 VARCHAR2(30);
44: l_party_id NUMBER;

Line 148: FROM ar_cmgt_credit_requests

144: , l_resp_id
145: , l_resp_appl_id
146: , l_security_group_id
147: , l_source_org_id -- Bug 7120635
148: FROM ar_cmgt_credit_requests
149: WHERE credit_request_id = l_credit_request_id;
150: EXCEPTION
151: WHEN NO_DATA_FOUND THEN
152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;