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 419: FROM okc_k_headers_b ia,

415: ia_okl.currency_conversion_type,
416: ia_okl.currency_conversion_rate,
417: ia_okl.currency_conversion_date,
418: ia_okl.legal_entity_id
419: FROM okc_k_headers_b ia,
420: okl_k_headers ia_okl
421: WHERE ia.contract_number = p_investor_agreement
422: AND ia_okl.id = ia.id;
423:

Line 830: okc_k_headers_b khr,

826: FROM
827: okl_strm_elements ste,
828: okl_streams stm,
829: okl_strm_type_v sty,
830: okc_k_headers_b khr,
831: okl_k_headers oklh
832: WHERE trunc(ste.stream_element_date) <= trunc(NVL(p_date_to, SYSDATE))
833: AND ste.amount <> 0
834: AND stm.id = ste.stm_id

Line 887: okc_k_headers_b khr,

883: okl_strm_elements ste1,
884: -- End Bug 4550607
885: okl_streams stm,
886: okl_strm_type_v sty,
887: okc_k_headers_b khr,
888: okl_k_headers khl,
889: okc_statuses_b khs ,
890: --Added by bkatraga for bug 6983321
891: okl_pools pl,

Line 1110: contract_number okc_k_headers_b.contract_number%type,

1106: -- xpi_id okl_ext_pay_invs_v.id%TYPE,
1107: -- xlp_id okl_xtl_pay_invs_v.id%TYPE,
1108: proc_sel_id okl_strm_elements.id%TYPE,
1109: bill_date DATE,
1110: contract_number okc_k_headers_b.contract_number%type,
1111: stream_name okl_strm_type_v.name%type,
1112: amount okl_strm_elements.amount%type,
1113: error_message Varchar2(2000)
1114: );

Line 1128: contract_number okc_k_headers_b.contract_number%type,

1124: -- xpi_id okl_ext_pay_invs_v.id%TYPE,
1125: -- xlp_id okl_xtl_pay_invs_v.id%TYPE,
1126: proc_sel_id okl_strm_elements.id%TYPE,
1127: bill_date DATE,
1128: contract_number okc_k_headers_b.contract_number%type,
1129: stream_name okl_strm_type_v.name%type,
1130: amount okl_strm_elements.amount%type,
1131: error_message Varchar2(2000)
1132: );

Line 1153: l_org_id okc_k_headers_b.authoring_org_id%TYPE;

1149:
1150: -----------------------------------------------------------------
1151: -- Process Variables And Cursors
1152: -----------------------------------------------------------------
1153: l_org_id okc_k_headers_b.authoring_org_id%TYPE;
1154: l_sob_id HR_OPERATING_UNITS.set_of_books_id%TYPE;
1155: l_try_id okl_trx_types_v.id%TYPE;
1156: l_sty_id okl_strm_type_v.id%TYPE;
1157: l_pdt_id okl_products_v.id%TYPE;

Line 1346: contract_number okc_k_headers_b.contract_number%type,

1342: xpi_id okl_ext_pay_invs_v.id%TYPE,
1343: xlp_id okl_xtl_pay_invs_v.id%TYPE,
1344: proc_sel_id okl_strm_elements.id%TYPE,
1345: bill_date DATE,
1346: contract_number okc_k_headers_b.contract_number%type,
1347: stream_name okl_strm_type_v.name%type,
1348: amount okl_strm_elements.amount%type,
1349: error_message Varchar2(2000)
1350: );