APPS.JTF_RS_ROLE_RELATE_VUHK dependencies on CN_ROLE_PMT_PLANS

Line 107: FROM cn_role_pmt_plans

103: x_loading_status OUT NOCOPY VARCHAR2 ) IS
104:
105: CURSOR l_cur IS
106: SELECT role_pmt_plan_id
107: FROM cn_role_pmt_plans
108: WHERE role_id = p_role_id;
109:
110: l_rec l_cur%ROWTYPE;
111:

Line 410: FROM cn_role_pmt_plans

406:
407:
408: CURSOR l_cur IS
409: SELECT role_pmt_plan_id
410: FROM cn_role_pmt_plans
411: WHERE role_id = p_role_id;
412:
413: l_rec l_cur%ROWTYPE;
414: l_return_status VARCHAR2(2000);

Line 574: FROM cn_role_pmt_plans

570: x_loading_status OUT NOCOPY VARCHAR2 ) IS
571:
572: CURSOR l_cur IS
573: SELECT role_pmt_plan_id
574: FROM cn_role_pmt_plans
575: WHERE role_id = p_role_id;
576:
577: l_rec l_cur%ROWTYPE;
578: l_return_status VARCHAR2(2000);