APPS.OKL_CS_LC_CONTRACT_PVT dependencies on HZ_PARTIES

Line 1298: FROM ar_lookups A, hz_parties p

1294: RETURN VARCHAR2 IS
1295: l_party_type_name VARCHAR2(2000);
1296: CURSOR C_party_type_name (p_object_id NUMBER) IS
1297: SELECT A.meaning
1298: FROM ar_lookups A, hz_parties p
1299: WHERE p.party_id = p_object_id
1300: AND A.lookup_code = p.party_type
1301: AND A.lookup_type = 'PARTY_TYPE';
1302:

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