APPS.OKL_CS_LC_CONTRACT_PVT dependencies on OKC_STATUSES_V

Line 419: OKC_STATUSES_V STS1

415: OKC_LINE_STYLES_B LS1,
416: OKL_ASSET_SUBSIDY_UV SUB,
417: OKL_SUBSIDIES_B SUBB,
418: OKL_SUBSIDIES_TL SUBT,
419: OKC_STATUSES_V STS1
420: where KLE1.ID = CLE1.ID
421: AND CLE1.LSE_ID = LS1.ID
422: AND LS1.LTY_CODE ='SUBSIDY'
423: AND cle1.dnz_chr_id = c_contract_id -- from parameter

Line 1484: HZ_PARTIES P,OKC_K_HEADERS_V CHR,OKC_STATUSES_V STAT

1480: -- get org_id for contract
1481: CURSOR get_contract_no (p_cust_acct_id IN VARCHAR2) IS
1482: SELECT COUNT(*)
1483: FROM HZ_CUST_ACCOUNTS CA,
1484: HZ_PARTIES P,OKC_K_HEADERS_V CHR,OKC_STATUSES_V STAT
1485: WHERE CHR.scs_code = 'LEASE' AND
1486: CHR.authoring_org_id = mo_global.get_current_org_id() AND
1487: ca.cust_account_id =chr.cust_acct_id AND
1488: ca.party_id = p.party_id AND