APPS.AR_CMGT_WF_ENGINE dependencies on HZ_CUST_PROFILE_AMTS

Line 2674: UPDATE hz_cust_profile_amts

2670: ELSIF p_credit_recommendation = 'TXN_CREDIT_LIMIT'
2671: THEN
2672: IF p_site_use_id IS NULL
2673: THEN
2674: UPDATE hz_cust_profile_amts
2675: set trx_credit_limit = p_reco_value2,
2676: last_update_date = sysdate,
2677: last_updated_by = fnd_global.user_id,
2678: last_update_login = fnd_global.login_id

Line 2688: UPDATE hz_cust_profile_amts

2684: AND site_use_id IS NULL )
2685: AND currency_code = p_reco_value1;
2686: ELSIF p_site_use_id IS NOT NULL
2687: THEN
2688: UPDATE hz_cust_profile_amts
2689: set trx_credit_limit = p_reco_value2,
2690: last_update_date = sysdate,
2691: last_updated_by = fnd_global.user_id,
2692: last_update_login = fnd_global.login_id

Line 2705: UPDATE hz_cust_profile_amts

2701: ELSIF p_credit_recommendation = 'CREDIT_LIMIT'
2702: THEN
2703: IF p_site_use_id IS NULL
2704: THEN
2705: UPDATE hz_cust_profile_amts
2706: set overall_credit_limit = p_reco_value2,
2707: last_update_date = sysdate,
2708: last_updated_by = fnd_global.user_id,
2709: last_update_login = fnd_global.login_id

Line 2719: UPDATE hz_cust_profile_amts

2715: AND site_use_id IS NULL )
2716: AND currency_code = p_reco_value1;
2717: ELSIF p_site_use_id IS NOT NULL
2718: THEN
2719: UPDATE hz_cust_profile_amts
2720: set overall_credit_limit = p_reco_value2,
2721: last_update_date = sysdate,
2722: last_updated_by = fnd_global.user_id,
2723: last_update_login = fnd_global.login_id

Line 2783: UPDATE hz_cust_profile_amts

2779: ELSIF p_credit_recommendation = 'PERCENT_CREDIT_LIMIT'
2780: THEN
2781: IF p_site_use_id IS NULL
2782: THEN
2783: UPDATE hz_cust_profile_amts
2784: set overall_credit_limit = (overall_credit_limit +
2785: ( overall_credit_limit * p_reco_value2/100)),
2786: last_update_date = sysdate,
2787: last_updated_by = fnd_global.user_id,

Line 2798: UPDATE hz_cust_profile_amts

2794: AND site_use_id IS NULL )
2795: AND currency_code = p_reco_value1;
2796: ELSIF p_site_use_id IS NOT NULL
2797: THEN
2798: UPDATE hz_cust_profile_amts
2799: set overall_credit_limit = (overall_credit_limit +
2800: ( overall_credit_limit * p_reco_value2/100)),
2801: last_update_date = sysdate,
2802: last_updated_by = fnd_global.user_id,

Line 2816: UPDATE hz_cust_profile_amts

2812: ELSIF p_credit_recommendation = 'PERCENT_TXN_CREDIT_LIMIT'
2813: THEN
2814: IF p_site_use_id IS NULL
2815: THEN
2816: UPDATE hz_cust_profile_amts
2817: set trx_credit_limit = (trx_credit_limit +
2818: ( trx_credit_limit * p_reco_value2/100)),
2819: last_update_date = sysdate,
2820: last_updated_by = fnd_global.user_id,

Line 2831: UPDATE hz_cust_profile_amts

2827: AND site_use_id IS NULL )
2828: AND currency_code = p_reco_value1;
2829: ELSIF p_site_use_id IS NOT NULL
2830: THEN
2831: UPDATE hz_cust_profile_amts
2832: set trx_credit_limit = (trx_credit_limit +
2833: ( trx_credit_limit * p_reco_value2/100)),
2834: last_update_date = sysdate,
2835: last_updated_by = fnd_global.user_id,

Line 3565: FROM hz_cust_profile_amts hzp

3561:
3562: BEGIN
3563: SELECT nvl(overall_credit_limit,0)
3564: INTO l_credit_limit
3565: FROM hz_cust_profile_amts hzp
3566: WHERE cust_account_profile_id = (
3567: SELECT cust_account_profile_id
3568: FROM hz_customer_profiles
3569: WHERE party_id = l_party_id