APPS.OKS_IB_UTIL_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 365: ,Okc_k_headers_all_b kh

361: Select v.resource_name sales_person
362: From jtf_rs_salesreps jtf
363: , jtf_rs_resource_extns_vl v
364: , okc_contacts oc1
365: ,Okc_k_headers_all_b kh
366:
367: Where oc1.dnz_chr_id = P_contract_id
368: And Kh.id = oc1.dnz_chr_id
369: And Kh.authoring_org_id = jtf.org_id

Line 817: From okc_k_headers_all_b kh

813: l_return_status Varchar2(1);
814: Cursor l_chr_csr Is
815: Select authoring_org_id,
816: inv_organization_id
817: From okc_k_headers_all_b kh
818: , okc_k_lines_b kl
819: Where kl.id = p_line_id
820: And kh.id = kl.dnz_chr_id;
821:

Line 855: From Okc_k_headers_all_b okc, Oks_Instance_k_dtls_temp tmp

851:
852:
853: Cursor get_ou_csr Is
854: Select distinct(okc.authoring_org_id) org_id
855: From Okc_k_headers_all_b okc, Oks_Instance_k_dtls_temp tmp
856: where tmp.Contract_id = okc.Id
857: And tmp.Parent_id = p_batch_Id;
858:
859: Cursor l_party_csr Is

Line 1430: , OKC_K_HEADERS_all_B KH

1426: , Coverage_term_full_amount(KI.Cle_id,Ks1.transfer_option,p_new_account_id,p_transaction_date,tmp.instance_id,kl.end_date) Coverage_full_amount
1427: , Get_date_terminated(St.ste_code,p_transaction_date,kl.start_date, kl.end_date)
1428:
1429: From OKC_K_ITEMS KI
1430: , OKC_K_HEADERS_all_B KH
1431: , OKC_K_LINES_B KL
1432: , OKC_STATUSES_B ST
1433: , Oks_Instance_k_dtls_temp tmp
1434: , OKS_K_LINES_B KS

Line 1485: , OKC_K_HEADERS_ALL_B KH

1481: , 0
1482: , 0
1483: , Get_date_terminated(St.ste_code,p_transaction_date,kl.start_date, Kl.end_date)
1484: From OKC_K_ITEMS KI
1485: , OKC_K_HEADERS_ALL_B KH
1486: , OKC_K_LINES_B KL
1487: , OKC_STATUSES_B ST
1488: , Oks_Instance_k_dtls_temp tmp
1489: , OKC_STATUSES_B HST

Line 1537: ,OKC_K_HEADERS_ALL_B KH

1533: , 0
1534: , 0
1535: , Get_date_terminated(St.ste_code,p_transaction_date,kl.start_date, Kl.end_date)
1536: From OKC_K_ITEMS KI
1537: ,OKC_K_HEADERS_ALL_B KH
1538: ,OKC_K_LINES_B KL
1539: ,OKC_STATUSES_B ST
1540: ,csi_counter_associations ctrAsc
1541: , Oks_Instance_k_dtls_temp tmp

Line 1591: , OKC_K_HEADERS_ALL_B KH

1587: , 0
1588: , 0
1589: , null
1590: From OKC_K_ITEMS_V KI
1591: , OKC_K_HEADERS_ALL_B KH
1592: , OKC_K_LINES_B KL
1593: , OKC_STATUSES_B ST
1594: , OKS_K_LINES_B KS
1595: , Oks_k_lines_b KS1

Line 2144: okc_k_headers_all_b kh,

2140: SELECT prl.object1_id1 party_id,
2141: kh.authoring_org_id org_id,
2142: kh.inv_organization_id
2143: FROM okc_k_party_roles_b prl,
2144: okc_k_headers_all_b kh,
2145: okc_k_lines_b ksl
2146: WHERE ksl.ID = p_line_id
2147: AND ksl.dnz_chr_id = kh.ID
2148: AND prl.dnz_chr_id = kh.ID