DBA Data[Home] [Help]

APPS.HZ_CREDIT_REQUEST_PVT dependencies on AR_CMGT_CREDIT_REQUESTS

Line 293: l_limit_currency AR_CMGT_CREDIT_REQUESTS.limit_currency%TYPE;

289: l_key VARCHAR2(240);
290: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type;
291: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
292: l_credit_check_rule_id NUMBER;
293: l_limit_currency AR_CMGT_CREDIT_REQUESTS.limit_currency%TYPE;
294: l_trx_amount NUMBER;
295: l_trx_currency AR_CMGT_CREDIT_REQUESTS.trx_currency%TYPE;
296: l_source_name VARCHAR2(50); --9509804
297: l_source_column1 NUMBER;

Line 295: l_trx_currency AR_CMGT_CREDIT_REQUESTS.trx_currency%TYPE;

291: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
292: l_credit_check_rule_id NUMBER;
293: l_limit_currency AR_CMGT_CREDIT_REQUESTS.limit_currency%TYPE;
294: l_trx_amount NUMBER;
295: l_trx_currency AR_CMGT_CREDIT_REQUESTS.trx_currency%TYPE;
296: l_source_name VARCHAR2(50); --9509804
297: l_source_column1 NUMBER;
298: l_source_column2 NUMBER;
299: l_source_column3 VARCHAR2(30);

Line 440: FROM ar_cmgt_credit_requests

436: , l_resp_id
437: , l_resp_appl_id
438: , l_security_group_id
439: , l_source_org_id -- Bug 7120635
440: FROM ar_cmgt_credit_requests
441: WHERE credit_request_id = l_credit_request_id;
442: EXCEPTION
443: WHEN NO_DATA_FOUND THEN
444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;