How to find customer credit limit amount in Oracle Apps R12

SELECT  a.overall_credit_limit
FROM   HZ_CUST_PROFILE_AMTS a
     , HZ_CUST_ACCOUNTS b
, ar_customers c
, hz_cust_site_uses_all d
, ar_payment_schedules_all e
, hz_cust_acct_sites_all f
, hz_party_sites g
WHERE    overall_credit_limit IS NOT NULL
         and a.cust_account_id = b.cust_account_id
         and b.account_number = c.customer_number
         and a.site_use_id = d.site_use_id
         and c.customer_id = e.customer_id
         --and e.STATUS <> 'CL'
         --AND e.CLASS = 'INV'
         and d.site_use_id = e.customer_site_use_id
         and c.customer_number = p_account_number
         and d.cust_acct_site_id = f.cust_acct_site_id
         and g.party_site_id = f.party_site_id
         and e.org_id =102;