DBA Data[Home] [Help]

APPS.OKS_KHR_PVT dependencies on HZ_PARTIES

Line 1488: HZ_PARTIES P,

1484: CURSOR csr_quote_to_person (p_contact_id IN NUMBER, p_org_id IN NUMBER) IS
1485: SELECT
1486: P.PARTY_ID
1487: FROM HZ_CUST_ACCOUNT_ROLES CAR,
1488: HZ_PARTIES P,
1489: HZ_RELATIONSHIPS R
1490: WHERE CAR.ROLE_TYPE = 'CONTACT'
1491: AND R.PARTY_ID = CAR.PARTY_ID
1492: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'

Line 2514: HZ_PARTIES P,

2510: CURSOR csr_quote_to_person (p_contact_id IN NUMBER, p_org_id IN NUMBER) IS
2511: SELECT
2512: P.PARTY_ID
2513: FROM HZ_CUST_ACCOUNT_ROLES CAR,
2514: HZ_PARTIES P,
2515: HZ_RELATIONSHIPS R
2516: WHERE CAR.ROLE_TYPE = 'CONTACT'
2517: AND R.PARTY_ID = CAR.PARTY_ID
2518: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'