[Home] [Help]
3534:
3535:
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