APPS.AR_CMGT_WF_ENGINE dependencies on HZ_CUST_PROFILE_CLASSES

Line 679: l_profile_class_name hz_cust_profile_classes.name%type;

675: l_employees_total hz_parties.employees_total%type;
676: l_credit_classification ar_cmgt_credit_requests.credit_classification%type;
677: l_amount ar_cmgt_credit_requests.limit_amount%type;
678: l_review_type ar_cmgt_credit_requests.review_type%type;
679: l_profile_class_name hz_cust_profile_classes.name%type;
680: l_currency ar_cmgt_credit_requests.limit_currency%type;
681: l_party_id hz_parties.party_id%type;
682:
683: /* 7132845 */

Line 776: hz_cust_profile_classes profclass,

772: l_amount, l_review_type, l_currency,
773: l_profile_class_name, l_postal_code, l_state, l_party_id
774: FROM ar_cmgt_credit_requests c,
775: hz_parties p,
776: hz_cust_profile_classes profclass,
777: hz_customer_profiles prof
778: WHERE c.credit_request_id = p_credit_request_id
779: AND c.party_id = p.party_id
780: AND p.party_id = prof.party_id