APPS.OKS_CUSTOMER_ACCEPTANCE_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 253: FROM okc_k_party_roles_b r,

249: l_vendor_token_exists VARCHAR2 (1) := '';
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')

Line 264: FROM okc_k_party_roles_b r,

260: AND r.chr_id = p_chr_id;
261:
262: CURSOR csr_vendor_name IS
263: SELECT o.NAME AS vendor_name
264: FROM okc_k_party_roles_b r,
265: hr_all_organization_units o
266: WHERE o.organization_id = r.object1_id1
267: AND r.jtot_object1_code = 'OKX_OPERUNIT'
268: AND r.rle_code IN

Line 404: FROM okc_k_party_roles_b r,

400: l_vendor_token_exists VARCHAR2 (1) := '';
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')

Line 415: FROM okc_k_party_roles_b r,

411: AND r.chr_id = p_chr_id;
412:
413: CURSOR csr_vendor_name IS
414: SELECT o.NAME AS vendor_name
415: FROM okc_k_party_roles_b r,
416: hr_all_organization_units o
417: WHERE o.organization_id = r.object1_id1
418: AND r.jtot_object1_code = 'OKX_OPERUNIT'
419: AND r.rle_code IN

Line 551: FROM okc_k_party_roles_b r,

547: l_vendor_name VARCHAR2 (1000) := '';
548:
549: CURSOR csr_vendor_name IS
550: SELECT o.NAME AS vendor_name
551: FROM okc_k_party_roles_b r,
552: hr_all_organization_units o
553: WHERE o.organization_id = r.object1_id1
554: AND r.jtot_object1_code = 'OKX_OPERUNIT'
555: AND r.rle_code = 'VENDOR' -- gets only the VENDOR

Line 618: FROM okc_k_party_roles_b r,

614: l_customer_name VARCHAR2 (1000) := '';
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')

Line 688: FROM okc_k_party_roles_b

684: l_party_id NUMBER := '';
685:
686: CURSOR csr_k_party IS
687: SELECT object1_id1
688: FROM okc_k_party_roles_b
689: WHERE dnz_chr_id = p_chr_id
690: AND cle_id IS NULL
691: AND jtot_object1_code = 'OKX_PARTY'
692: AND rle_code = 'CUSTOMER';

Line 1020: FROM okc_k_party_roles_b r,

1016: CURSOR csr_cust_account_dtls IS
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