DBA Data[Home] [Help]

APPS.AR_CMGT_WF_ENGINE dependencies on HZ_CUST_PROFILE_CLASSES

Line 640: l_profile_class_name hz_cust_profile_classes.name%type;

636: l_employees_total hz_parties.employees_total%type;
637: l_credit_classification ar_cmgt_credit_requests.credit_classification%type;
638: l_amount ar_cmgt_credit_requests.limit_amount%type;
639: l_review_type ar_cmgt_credit_requests.review_type%type;
640: l_profile_class_name hz_cust_profile_classes.name%type;
641: l_currency ar_cmgt_credit_requests.limit_currency%type;
642: l_party_id hz_parties.party_id%type;
643:
644:

Line 659: hz_cust_profile_classes profclass,

655: l_amount, l_review_type, l_currency,
656: l_profile_class_name, l_postal_code, l_state, l_party_id
657: FROM ar_cmgt_credit_requests c,
658: hz_parties p,
659: hz_cust_profile_classes profclass,
660: hz_customer_profiles prof
661: WHERE c.credit_request_id = p_credit_request_id
662: AND c.party_id = p.party_id
663: AND p.party_id = prof.party_id