DBA Data[Home] [Help]

APPS.AR_ARXCCS_XMLP_PKG dependencies on HZ_CREDIT_PROFILES

Line 3540: From HZ_Credit_Profiles

3536: select count(*)
3537: into ct_prof
3538: from hz_credit_profile_amts cpa
3539: where credit_profile_id IN (Select credit_profile_id
3540: From HZ_Credit_Profiles
3541: Where organization_id = p_reporting_entity_id
3542: and effective_date_from <= SYSDATE
3543: and effective_date_to >= SYSDATE);
3544:

Line 3567: from HZ_credit_profiles cp,

3563: l_cred_summ_limit_tolerance,
3564: l_cred_summ_credit_rating,
3565: l_cred_summ_credit_hold,
3566: l_credit_profile_id
3567: from HZ_credit_profiles cp,
3568: ar_lookups lk
3569: where
3570: nvl(cp.credit_hold,'N') = lk.lookup_code
3571: and lk.lookup_type = 'YES/NO'