APPS.JTF_RS_SKILLS_REPORT_PUB dependencies on JTF_RS_PROBLEM_CODES_V

Line 150: cursor c_prob_name (l_problem_code jtf_rs_problem_codes_v.problem_name%type) is

146: select resource_name, resource_number
147: from jtf_rs_resource_extns_vl
148: where resource_id = p_resource_id;
149:
150: cursor c_prob_name (l_problem_code jtf_rs_problem_codes_v.problem_name%type) is
151: select problem_name
152: from jtf_rs_problem_codes_v
153: where problem_code = l_problem_code;
154:

Line 152: from jtf_rs_problem_codes_v

148: where resource_id = p_resource_id;
149:
150: cursor c_prob_name (l_problem_code jtf_rs_problem_codes_v.problem_name%type) is
151: select problem_name
152: from jtf_rs_problem_codes_v
153: where problem_code = l_problem_code;
154:
155: cursor c_plat_name (l_platform_id jtf_rs_products_v.product_name%type) is
156: select platform_name