APPS.JTF_RS_ROLE_RELATE_VUHK dependencies on CN_ROLE_PLANS

Line 53: FROM cn_role_plans

49: x_loading_status OUT NOCOPY VARCHAR2 ) IS
50:
51: CURSOR l_cur IS
52: SELECT role_plan_id, create_module
53: FROM cn_role_plans
54: WHERE role_id = p_role_id;
55:
56: l_rec l_cur%ROWTYPE;
57:

Line 319: FROM cn_role_plans

315:
316:
317: CURSOR l_cur IS
318: SELECT role_plan_id, create_module
319: FROM cn_role_plans
320: WHERE role_id = p_role_id;
321:
322: l_rec l_cur%ROWTYPE;
323: l_return_status VARCHAR2(2000);

Line 525: FROM cn_role_plans

521: x_loading_status OUT NOCOPY VARCHAR2 ) IS
522:
523: CURSOR l_cur IS
524: SELECT role_plan_id
525: FROM cn_role_plans
526: WHERE role_id = p_role_id;
527:
528: l_rec l_cur%ROWTYPE;
529: l_return_status VARCHAR2(2000);