DBA Data[Home] [Help]

APPS.OKL_BLK_AST_UPD_PVT dependencies on OKC_K_HEADERS_B

Line 1127: okc_k_headers_b chr

1123: ,chr.scs_code scs_code
1124: FROM okc_contacts ct,
1125: okc_contact_sources csrc,
1126: okc_k_party_roles_b pty,
1127: okc_k_headers_b chr
1128: WHERE ct.cpl_id = pty.id
1129: AND ct.cro_code = csrc.cro_code
1130: AND ct.jtot_object1_code = csrc.jtot_object_code
1131: AND ct.dnz_chr_id = chr.id

Line 1145: FROM okc_k_headers_b

1141:
1142: CURSOR custBillTo_csr
1143: IS
1144: SELECT bill_to_site_use_id cust_acct_site_id
1145: FROM okc_k_headers_b
1146: WHERE id = p_trxh_out_rec.khr_id;
1147:
1148: l_custBillTo_rec custBillTo_csr%ROWTYPE;
1149:

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

1314: ,x_msg_count OUT NOCOPY NUMBER
1315: ,x_msg_data OUT NOCOPY VARCHAR2)
1316: IS
1317:
1318: CURSOR contract_csr (p_contract_id OKC_K_HEADERS_B.ID%TYPE)
1319: IS
1320: SELECT khr.pdt_id product_id
1321: ,khr.start_date start_date
1322: ,khr.currency_code currency_code