APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on OKC_K_HEADERS_B

Line 47: FROM okc_k_headers_b chr

43: -- Cursor to fetch Org Id
44: -----------------------------------------------------------------
45: CURSOR org_id_csr ( p_chr_id NUMBER ) IS
46: SELECT chr.authoring_org_id
47: FROM okc_k_headers_b chr
48: WHERE id = p_chr_id;
49:
50: -----------------------------------------------------------------
51: -- Cursor to fetch Set Of Books

Line 434: FROM okc_k_headers_b ia,

430: ia_okl.currency_conversion_type,
431: ia_okl.currency_conversion_rate,
432: ia_okl.currency_conversion_date,
433: ia_okl.legal_entity_id
434: FROM okc_k_headers_b ia,
435: okl_k_headers ia_okl
436: WHERE ia.contract_number = p_investor_agreement
437: AND ia_okl.id = ia.id;
438:

Line 845: okc_k_headers_b khr,

841: FROM
842: okl_strm_elements ste,
843: okl_streams stm,
844: okl_strm_type_v sty,
845: okc_k_headers_b khr,
846: okl_k_headers oklh
847: WHERE trunc(ste.stream_element_date) <= trunc(NVL(p_date_to, SYSDATE))
848: AND ste.amount <> 0
849: AND stm.id = ste.stm_id

Line 902: okc_k_headers_b khr,

898: okl_strm_elements ste1,
899: -- End Bug 4550607
900: okl_streams stm,
901: okl_strm_type_v sty,
902: okc_k_headers_b khr,
903: okl_k_headers khl,
904: okc_statuses_b khs ,
905: --Added by bkatraga for bug 6983321
906: okl_pools pl,

Line 1180: contract_number okc_k_headers_b.contract_number%type,

1176: -- xpi_id okl_ext_pay_invs_v.id%TYPE,
1177: -- xlp_id okl_xtl_pay_invs_v.id%TYPE,
1178: proc_sel_id okl_strm_elements.id%TYPE,
1179: bill_date DATE,
1180: contract_number okc_k_headers_b.contract_number%type,
1181: stream_name okl_strm_type_v.name%type,
1182: amount okl_strm_elements.amount%type,
1183: error_message Varchar2(2000)
1184: );

Line 1198: contract_number okc_k_headers_b.contract_number%type,

1194: -- xpi_id okl_ext_pay_invs_v.id%TYPE,
1195: -- xlp_id okl_xtl_pay_invs_v.id%TYPE,
1196: proc_sel_id okl_strm_elements.id%TYPE,
1197: bill_date DATE,
1198: contract_number okc_k_headers_b.contract_number%type,
1199: stream_name okl_strm_type_v.name%type,
1200: amount okl_strm_elements.amount%type,
1201: error_message Varchar2(2000)
1202: );

Line 1223: l_org_id okc_k_headers_b.authoring_org_id%TYPE;

1219:
1220: -----------------------------------------------------------------
1221: -- Process Variables And Cursors
1222: -----------------------------------------------------------------
1223: l_org_id okc_k_headers_b.authoring_org_id%TYPE;
1224: l_sob_id HR_OPERATING_UNITS.set_of_books_id%TYPE;
1225: l_try_id okl_trx_types_v.id%TYPE;
1226: l_sty_id okl_strm_type_v.id%TYPE;
1227: l_pdt_id okl_products_v.id%TYPE;

Line 1416: contract_number okc_k_headers_b.contract_number%type,

1412: xpi_id okl_ext_pay_invs_v.id%TYPE,
1413: xlp_id okl_xtl_pay_invs_v.id%TYPE,
1414: proc_sel_id okl_strm_elements.id%TYPE,
1415: bill_date DATE,
1416: contract_number okc_k_headers_b.contract_number%type,
1417: stream_name okl_strm_type_v.name%type,
1418: amount okl_strm_elements.amount%type,
1419: error_message Varchar2(2000)
1420: );