DBA Data[Home] [Help]

APPS.OKS_KHR_PVT dependencies on HZ_CUST_ACCOUNT_ROLES

Line 1463: FROM HZ_CUST_ACCOUNT_ROLES CAR,

1459:
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

Line 2483: FROM HZ_CUST_ACCOUNT_ROLES CAR,

2479:
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