DBA Data[Home] [Help]

APPS.JTF_RS_RESOURCE_SKILLS_PVT dependencies on JTF_RS_PROBLEM_CODES_V

Line 203: FROM JTF_RS_PROBLEM_CODES_V

199: -- Check problem_code is valid
200: CURSOR problem_code_cur(ll_problem_code JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE)
201: IS
202: SELECT problem_code
203: FROM JTF_RS_PROBLEM_CODES_V
204: WHERE problem_code = ll_problem_code
205: AND enabled_flag = 'Y'
206: AND trunc(sysdate) between trunc(nvl(start_date_active, sysdate)) and
207: nvl(end_date_active, sysdate);