DBA Data[Home] [Help]

APPS.OKS_PM_PROGRAMS_PVT dependencies on OKX_PM_PROGRAMS_V

Line 4354: okx_pm_programs_v opv

4350: CURSOR l_prog_csr(p_cle_id IN NUMBER) IS
4351: select 'x' terminate
4352: FROM okc_k_lines_b cle,
4353: oks_k_lines_b pmp,
4354: okx_pm_programs_v opv
4355: WHERE cle.id = pmp.cle_id
4356: and cle.dnz_chr_id = pmp.dnz_chr_id
4357: and pmp.pm_program_id= opv.id1
4358: and cle.cle_id=p_cle_id

Line 4483: --okx_pm_programs_v opv

4479: CURSOR l_prog_csr(p_cle_id IN NUMBER) IS
4480: select opv.mr_header_id
4481: FROM okc_k_lines_b cle,
4482: oks_k_lines_b pmp,
4483: --okx_pm_programs_v opv
4484: ahl_mr_headers_b opv
4485: WHERE cle.id = pmp.cle_id
4486: and cle.dnz_chr_id = pmp.dnz_chr_id
4487: and pmp.pm_program_id= opv.mr_header_id