APPS.OKL_CS_LC_CONTRACT_PVT dependencies on HZ_PARTIES

Line 1260: FROM ar_lookups A, hz_parties p

1256: RETURN VARCHAR2 IS
1257: l_party_type_name VARCHAR2(2000);
1258: CURSOR C_party_type_name (p_object_id NUMBER) IS
1259: SELECT A.meaning
1260: FROM ar_lookups A, hz_parties p
1261: WHERE p.party_id = p_object_id
1262: AND A.lookup_code = p.party_type
1263: AND A.lookup_type = 'PARTY_TYPE';
1264:

Line 1446: HZ_PARTIES P,OKC_K_HEADERS_V CHR,OKC_STATUSES_V STAT

1442: -- get org_id for contract
1443: CURSOR get_contract_no (p_cust_acct_id IN VARCHAR2) IS
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