APPS.AR_CMGT_WF_ENGINE dependencies on HZ_CUST_PROFILE_AMTS

Line 2300: UPDATE hz_cust_profile_amts

2296: ELSIF p_credit_recommendation = 'TXN_CREDIT_LIMIT'
2297: THEN
2298: IF p_site_use_id IS NULL
2299: THEN
2300: UPDATE hz_cust_profile_amts
2301: set trx_credit_limit = p_reco_value2,
2302: last_update_date = sysdate,
2303: last_updated_by = fnd_global.user_id,
2304: last_update_login = fnd_global.login_id

Line 2314: UPDATE hz_cust_profile_amts

2310: AND site_use_id IS NULL )
2311: AND currency_code = p_reco_value1;
2312: ELSIF p_site_use_id IS NOT NULL
2313: THEN
2314: UPDATE hz_cust_profile_amts
2315: set trx_credit_limit = p_reco_value2,
2316: last_update_date = sysdate,
2317: last_updated_by = fnd_global.user_id,
2318: last_update_login = fnd_global.login_id

Line 2331: UPDATE hz_cust_profile_amts

2327: ELSIF p_credit_recommendation = 'CREDIT_LIMIT'
2328: THEN
2329: IF p_site_use_id IS NULL
2330: THEN
2331: UPDATE hz_cust_profile_amts
2332: set overall_credit_limit = p_reco_value2,
2333: last_update_date = sysdate,
2334: last_updated_by = fnd_global.user_id,
2335: last_update_login = fnd_global.login_id

Line 2345: UPDATE hz_cust_profile_amts

2341: AND site_use_id IS NULL )
2342: AND currency_code = p_reco_value1;
2343: ELSIF p_site_use_id IS NOT NULL
2344: THEN
2345: UPDATE hz_cust_profile_amts
2346: set overall_credit_limit = p_reco_value2,
2347: last_update_date = sysdate,
2348: last_updated_by = fnd_global.user_id,
2349: last_update_login = fnd_global.login_id

Line 2409: UPDATE hz_cust_profile_amts

2405: ELSIF p_credit_recommendation = 'PERCENT_CREDIT_LIMIT'
2406: THEN
2407: IF p_site_use_id IS NULL
2408: THEN
2409: UPDATE hz_cust_profile_amts
2410: set overall_credit_limit = (overall_credit_limit +
2411: ( overall_credit_limit * p_reco_value2/100)),
2412: last_update_date = sysdate,
2413: last_updated_by = fnd_global.user_id,

Line 2424: UPDATE hz_cust_profile_amts

2420: AND site_use_id IS NULL )
2421: AND currency_code = p_reco_value1;
2422: ELSIF p_site_use_id IS NOT NULL
2423: THEN
2424: UPDATE hz_cust_profile_amts
2425: set overall_credit_limit = (overall_credit_limit +
2426: ( overall_credit_limit * p_reco_value2/100)),
2427: last_update_date = sysdate,
2428: last_updated_by = fnd_global.user_id,

Line 2442: UPDATE hz_cust_profile_amts

2438: ELSIF p_credit_recommendation = 'PERCENT_TXN_CREDIT_LIMIT'
2439: THEN
2440: IF p_site_use_id IS NULL
2441: THEN
2442: UPDATE hz_cust_profile_amts
2443: set trx_credit_limit = (trx_credit_limit +
2444: ( trx_credit_limit * p_reco_value2/100)),
2445: last_update_date = sysdate,
2446: last_updated_by = fnd_global.user_id,

Line 2457: UPDATE hz_cust_profile_amts

2453: AND site_use_id IS NULL )
2454: AND currency_code = p_reco_value1;
2455: ELSIF p_site_use_id IS NOT NULL
2456: THEN
2457: UPDATE hz_cust_profile_amts
2458: set trx_credit_limit = (trx_credit_limit +
2459: ( trx_credit_limit * p_reco_value2/100)),
2460: last_update_date = sysdate,
2461: last_updated_by = fnd_global.user_id,

Line 3135: FROM hz_cust_profile_amts hzp

3131:
3132: BEGIN
3133: SELECT nvl(overall_credit_limit,0)
3134: INTO l_credit_limit
3135: FROM hz_cust_profile_amts hzp
3136: WHERE cust_account_profile_id = (
3137: SELECT cust_account_profile_id
3138: FROM hz_customer_profiles
3139: WHERE party_id = l_party_id