DBA Data[Home] [Help]

APPS.OKS_PM_PROGRAMS_PVT dependencies on OKX_PM_ACTIVITIES_V

Line 4368: okx_pm_activities_v act

4364: select 'x' terminate
4365: FROM okc_k_lines_b cle,
4366: oks_k_lines_b pmp,
4367: oks_pm_activities oksact,
4368: okx_pm_activities_v act
4369: WHERE cle.id = pmp.cle_id
4370: and cle.dnz_chr_id = pmp.dnz_chr_id
4371: --changed for using index and pmp.pm_program_id= oksact.program_id
4372: and pmp.cle_id= oksact.cle_id

Line 4837: okx_pm_activities_v act

4833: CURSOR l_prog_csr(p_cle_id IN NUMBER) IS
4834: SELECT act.id1 activity_id
4835: FROM okc_k_lines_b cle,
4836: oks_k_lines_b okscle,
4837: okx_pm_activities_v act
4838: WHERE cle.id = okscle.cle_id
4839: and cle.dnz_chr_id = okscle.dnz_chr_id
4840: and okscle.pm_program_id= act.program_id
4841: and cle.id =p_cle_id