APPS.AR_CMGT_DATA_POINTS_PKG dependencies on AR_CMGT_CREDIT_REQUESTS

Line 1217: FROM ar_cmgt_credit_requests

1213: BEGIN
1214: -- Now if OM is installed get credit_check_rule_id
1215: SELECT credit_check_rule_id
1216: INTO l_credit_check_rule_id
1217: FROM ar_cmgt_credit_requests
1218: WHERE credit_request_id = p_credit_request_id;
1219:
1220: IF l_credit_check_rule_id IS NULL
1221: THEN

Line 1844: FROM ar_cmgt_credit_requests

1840: market_capitalization,
1841: nvl(limit_amount, trx_amount) requested_amount,
1842: market_cap_monetary_unit,
1843: legal_entity_name
1844: FROM ar_cmgt_credit_requests
1845: WHERE credit_request_id = p_credit_request_id;
1846:
1847: CURSOR c_case_folder IS
1848: SELECT last_updated, -- last_credit_review_date

Line 4544: from ar_cmgt_credit_requests

4540: CURSOR getCreditRequestDetails (p_cr_req_id IN NUMBER)
4541: IS
4542: select credit_check_rule_id,
4543: source_name
4544: from ar_cmgt_credit_requests
4545: where credit_request_id = p_cr_req_id;
4546:
4547:
4548: CURSOR getRateTYpeFromCreditChkRule(p_cr_chk_rule_id IN NUMBER) IS

Line 5710: FROM ar_cmgt_credit_requests

5706: BEGIN
5707: -- Get source_information
5708: SELECT nvl(source_name, 'OCM'), nvl(source_column1, -99)
5709: INTO g_source_name, g_source_id
5710: FROM ar_cmgt_credit_requests
5711: WHERE credit_request_id = p_credit_request_id;
5712:
5713: EXCEPTION
5714: WHEN OTHERS THEN

Line 5819: update ar_cmgt_credit_requests

5815: END IF;
5816: END IF;
5817:
5818: -- update credit request with the limit currency
5819: update ar_cmgt_credit_requests
5820: set limit_currency = l_limit_currency,
5821: LAST_UPDATE_DATE = sysdate,
5822: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5823: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id