1444: SELECT COUNT(*)
1445: FROM HZ_CUST_ACCOUNTS CA,
1446: HZ_PARTIES P,OKC_K_HEADERS_V CHR,OKC_STATUSES_V STAT
1447: WHERE CHR.scs_code = 'LEASE' AND
1448: CHR.authoring_org_id = mo_global.get_current_org_id() AND
1449: ca.cust_account_id =chr.cust_acct_id AND
1450: ca.party_id = p.party_id AND
1451: CHR.sts_code = stat.code AND
1452: stat.code = 'BOOKED' AND