eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_ROLE_PMT_PLANS_PVT dependencies on CN_ROLE_PLANS

Line 371: CURSOR l_cur(l_role_id cn_role_plans.role_id%TYPE,

367: l_api_name CONSTANT VARCHAR2(30) := 'check_valid_update';
368: tmp_start_date cn_role_pmt_plans.start_date%TYPE;
369: tmp_end_date cn_role_pmt_plans.end_date%TYPE;
370:
371: CURSOR l_cur(l_role_id cn_role_plans.role_id%TYPE,
372: l_role_pmt_plan_id cn_role_pmt_plans.role_pmt_plan_id%TYPE) IS
373: SELECT start_date, end_date, pmt_plan_id
374: FROM cn_role_pmt_plans
375: WHERE role_id = l_role_id AND

Line 402: -- old role_plan_id must exist in cn_role_plans

398: -- Start of API body
399:
400: -- validate the following issues
401:
402: -- old role_plan_id must exist in cn_role_plans
403: x_role_pmt_plan_id_old :=
404: cn_api.get_role_pmt_plan_id(p_role_pmt_plan_rec_old.role_name,
405: p_role_pmt_plan_rec_old.pmt_plan_name,
406: p_role_pmt_plan_rec_old.start_date,