DBA Data[Home] [Help]

APPS.OKL_BLK_AST_UPD_PVT dependencies on OKC_K_HEADERS_B

Line 1095: okc_k_headers_b chr

1091: ,chr.scs_code scs_code
1092: FROM okc_contacts ct,
1093: okc_contact_sources csrc,
1094: okc_k_party_roles_b pty,
1095: okc_k_headers_b chr
1096: WHERE ct.cpl_id = pty.id
1097: AND ct.cro_code = csrc.cro_code
1098: AND ct.jtot_object1_code = csrc.jtot_object_code
1099: AND ct.dnz_chr_id = chr.id

Line 1113: FROM okc_k_headers_b

1109:
1110: CURSOR custBillTo_csr
1111: IS
1112: SELECT bill_to_site_use_id cust_acct_site_id
1113: FROM okc_k_headers_b
1114: WHERE id = p_trxh_out_rec.khr_id;
1115:
1116: l_custBillTo_rec custBillTo_csr%ROWTYPE;
1117:

Line 1286: CURSOR contract_csr (p_contract_id OKC_K_HEADERS_B.ID%TYPE)

1282: ,x_msg_count OUT NOCOPY NUMBER
1283: ,x_msg_data OUT NOCOPY VARCHAR2)
1284: IS
1285:
1286: CURSOR contract_csr (p_contract_id OKC_K_HEADERS_B.ID%TYPE)
1287: IS
1288: SELECT khr.pdt_id product_id
1289: ,khr.start_date start_date
1290: ,khr.currency_code currency_code