DBA Data[Home] [Help]

APPS.OKS_KHR_PVT dependencies on HZ_CUST_ACCOUNT_ROLES

Line 1487: FROM HZ_CUST_ACCOUNT_ROLES CAR,

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

Line 2513: FROM HZ_CUST_ACCOUNT_ROLES CAR,

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