DBA Data[Home] [Help]

APPS.OKS_KHR_PVT dependencies on HZ_PARTIES

Line 1464: HZ_PARTIES P,

1460: CURSOR csr_quote_to_person (p_contact_id IN NUMBER, p_org_id IN NUMBER) IS
1461: SELECT
1462: P.PARTY_ID
1463: FROM HZ_CUST_ACCOUNT_ROLES CAR,
1464: HZ_PARTIES P,
1465: HZ_RELATIONSHIPS R
1466: WHERE CAR.ROLE_TYPE = 'CONTACT'
1467: AND R.PARTY_ID = CAR.PARTY_ID
1468: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'

Line 2484: HZ_PARTIES P,

2480: CURSOR csr_quote_to_person (p_contact_id IN NUMBER, p_org_id IN NUMBER) IS
2481: SELECT
2482: P.PARTY_ID
2483: FROM HZ_CUST_ACCOUNT_ROLES CAR,
2484: HZ_PARTIES P,
2485: HZ_RELATIONSHIPS R
2486: WHERE CAR.ROLE_TYPE = 'CONTACT'
2487: AND R.PARTY_ID = CAR.PARTY_ID
2488: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'