APPS.OKS_RENCON_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 174: okc_k_party_roles_b pr,

170: h.inv_organization_id,
171: pr.object1_id1,
172: h.currency_code
173: FROM okc_K_Headers_all_b h, --mmadhavi MOAC - changed to _ALL_B for performance
174: okc_k_party_roles_b pr,
175: okc_k_party_roles_b pr1,
176: okc_statuses_b st
177: WHERE h.id = p_target_id
178: AND h.id = pr.dnz_chr_id AND pr.cle_id IS NULL

Line 175: okc_k_party_roles_b pr1,

171: pr.object1_id1,
172: h.currency_code
173: FROM okc_K_Headers_all_b h, --mmadhavi MOAC - changed to _ALL_B for performance
174: okc_k_party_roles_b pr,
175: okc_k_party_roles_b pr1,
176: okc_statuses_b st
177: WHERE h.id = p_target_id
178: AND h.id = pr.dnz_chr_id AND pr.cle_id IS NULL
179: AND pr.rle_code = 'CUSTOMER'

Line 249: okc_k_party_roles_b pr,

245: -- Added for bug # 2870380
246: CURSOR get_correct_status(l_source_chr_id IN NUMBER, l_source_subline_id IN NUMBER) IS
247: SELECT h.id
248: FROM okc_K_Headers_all_b h, --mmadhavi MOAC - changed to _ALL_B for performance
249: okc_k_party_roles_b pr,
250: okc_statuses_b st
251: , okc_k_lines_b s
252: WHERE h.id = l_source_chr_id
253: AND h.scs_code IN ('WARRANTY', x_scs_code)

Line 471: okc_k_party_roles_b pr,

467: h.inv_organization_id,
468: pr.object1_id1,
469: h.currency_code
470: FROM okc_K_Headers_all_b h, --mmadhavi MOAC - changed to _ALL_B for performance
471: okc_k_party_roles_b pr,
472: okc_k_party_roles_b pr1,
473: okc_statuses_b st
474: WHERE h.id = p_target_id
475: AND h.id = pr.dnz_chr_id AND pr.cle_id IS NULL

Line 472: okc_k_party_roles_b pr1,

468: pr.object1_id1,
469: h.currency_code
470: FROM okc_K_Headers_all_b h, --mmadhavi MOAC - changed to _ALL_B for performance
471: okc_k_party_roles_b pr,
472: okc_k_party_roles_b pr1,
473: okc_statuses_b st
474: WHERE h.id = p_target_id
475: AND h.id = pr.dnz_chr_id AND pr.cle_id IS NULL
476: AND pr.rle_code = 'CUSTOMER'

Line 496: okc_k_party_roles_b pr,

492: CURSOR valid_header_sources(p_target_id IN NUMBER) IS
493: SELECT
494: h.id
495: FROM okc_K_Headers_all_b h, --mmadhavi MOAC - changed to _ALL_B for performance
496: okc_k_party_roles_b pr,
497: okc_statuses_b st
498: WHERE h.scs_code IN ('WARRANTY', x_scs_code)
499: AND h.chr_type = x_chr_type
500: AND h.template_yn = x_template_yn

Line 519: okc_k_party_roles_b pr,

515: CURSOR valid_header_sources_eur(p_target_id IN NUMBER) IS
516: SELECT
517: h.id
518: FROM okc_K_Headers_all_b h, --mmadhavi MOAC - changed to _ALL_B for performance
519: okc_k_party_roles_b pr,
520: okc_statuses_b st
521: WHERE h.scs_code IN ('WARRANTY', x_scs_code)
522: AND h.chr_type = x_chr_type
523: AND h.template_yn = x_template_yn

Line 1329: okc_k_party_roles_b pr,

1325: CURSOR valid_target (p_target_id IN NUMBER) IS
1326: SELECT
1327: 'X'
1328: FROM okc_K_Headers_all_b h,
1329: okc_k_party_roles_b pr,
1330: okc_k_party_roles_b pr1,
1331: okc_statuses_b st
1332: WHERE h.id = p_target_id
1333: AND h.id = pr.dnz_chr_id AND pr.cle_id IS NULL

Line 1330: okc_k_party_roles_b pr1,

1326: SELECT
1327: 'X'
1328: FROM okc_K_Headers_all_b h,
1329: okc_k_party_roles_b pr,
1330: okc_k_party_roles_b pr1,
1331: okc_statuses_b st
1332: WHERE h.id = p_target_id
1333: AND h.id = pr.dnz_chr_id AND pr.cle_id IS NULL
1334: AND pr.rle_code = 'CUSTOMER'

Line 1908: okc_k_party_roles_b pr,

1904: h.inv_organization_id,
1905: pr.object1_id1,
1906: h.currency_code
1907: FROM okc_K_Headers_all_b h,
1908: okc_k_party_roles_b pr,
1909: okc_statuses_b st
1910: WHERE
1911: h.id=pr.dnz_chr_id and pr.cle_id is null
1912: and pr.rle_code = 'CUSTOMER'