APPS.OKL_SLA_ACC_SOURCES_PVT dependencies on OKL_K_HEADERS

Line 59: ,okl_k_headers khr

55: ,hr_org.NAME hr_org_name
56: ,khr.pdt_id pdt_id
57: ,chr.scs_code scs_code
58: FROM okc_k_headers_all_b chr
59: ,okl_k_headers khr
60: ,hr_all_organization_units hr_org
61: WHERE khr.id = l_khr_id
62: AND chr.id = khr.id
63: AND hr_org.organization_id = chr.authoring_org_id;

Line 122: ,okl_k_headers ia_khr

118: ,ia_chr.START_DATE ia_start_date
119: ,ia_pdt.NAME ia_product_name
120: FROM okl_pool_contents ia_pool_c
121: ,okc_k_headers_all_b ia_chr
122: ,okl_k_headers ia_khr
123: ,okl_products ia_pdt
124: ,okl_pools_all ia_pool
125: WHERE ia_pool_c.sty_code = p_sty_type
126: AND ia_pool_c.pol_id = ia_pool.id

Line 225: ,okl_k_headers khr

221: CURSOR c_vendor_program_number_csr (p_khr_id NUMBER)
222: IS
223: SELECT vp_chr.contract_number
224: FROM okc_k_headers_all_b vp_chr
225: ,okl_k_headers khr
226: WHERE vp_chr.id = khr.khr_id
227: AND vp_chr.scs_code = 'PROGRAM'
228: AND khr.id = p_khr_id;
229:

Line 389: FROM okl_k_headers khr

385: ,khr.attribute12
386: ,khr.attribute13
387: ,khr.attribute14
388: ,khr.attribute15
389: FROM okl_k_headers khr
390: WHERE khr.id = l_khr_id;
391:
392: -- for book classification code and tax owner code
393: CURSOR c_pdt_bc_to_icm_rrb_csr(p_pdt_id NUMBER)

Line 581: ,okl_k_headers invk

577: ,invc.currency_code inv_agrmnt_currency_code
578: ,invc.START_DATE inv_agrmnt_effective_from
579: ,invc.sts_code inv_agrmnt_status_code
580: FROM okc_k_headers_all_b invc
581: ,okl_k_headers invk
582: ,okl_pools_all pol
583: WHERE invc.id = invk.id
584: AND invc.scs_code = G_INVESTOR
585: AND pol.khr_id = invk.id