APPS.OKS_CUSTOMER_ACCEPTANCE_PVT dependencies on HZ_PARTIES

Line 254: hz_parties p

250:
251: CURSOR csr_customer_name IS
252: SELECT p.party_name AS customer_name
253: FROM okc_k_party_roles_b r,
254: hz_parties p
255: WHERE p.party_id = r.object1_id1
256: AND r.jtot_object1_code = 'OKX_PARTY'
257: AND r.rle_code IN ('CUSTOMER', 'SUBSCRIBER')
258: -- gets only the CUSTOMER /SUBSCRIBER

Line 405: hz_parties p

401:
402: CURSOR csr_customer_name IS
403: SELECT p.party_name AS customer_name
404: FROM okc_k_party_roles_b r,
405: hz_parties p
406: WHERE p.party_id = r.object1_id1
407: AND r.jtot_object1_code = 'OKX_PARTY'
408: AND r.rle_code IN ('CUSTOMER', 'SUBSCRIBER')
409: -- gets only the CUSTOMER /SUBSCRIBER

Line 619: hz_parties p

615:
616: CURSOR csr_customer_name IS
617: SELECT p.party_name AS customer_name
618: FROM okc_k_party_roles_b r,
619: hz_parties p
620: WHERE p.party_id = r.object1_id1
621: AND r.jtot_object1_code = 'OKX_PARTY'
622: AND r.rle_code IN ('CUSTOMER', 'SUBSCRIBER')
623: -- gets only the CUSTOMER /SUBSCRIBER

Line 1021: hz_parties p,

1017: SELECT p.party_name AS customer_name,
1018: r.object1_id1 AS party_id,
1019: ca.cust_account_id AS customer_account_id
1020: FROM okc_k_party_roles_b r,
1021: hz_parties p,
1022: hz_cust_accounts ca
1023: WHERE p.party_id = r.object1_id1
1024: AND ca.party_id = p.party_id
1025: AND r.jtot_object1_code = 'OKX_PARTY'