APPS.CN_API dependencies on CN_ROLE_PMT_PLANS

Line 1369: ) RETURN cn_role_pmt_plans.role_pmt_plan_id%TYPE IS

1365: p_pmt_plan_name IN VARCHAR2,
1366: p_start_date IN DATE,
1367: p_end_date IN DATE,
1368: p_org_id IN NUMBER
1369: ) RETURN cn_role_pmt_plans.role_pmt_plan_id%TYPE IS
1370:
1371: CURSOR l_cur(l_role_id cn_role_pmt_plans.role_id%TYPE,
1372: l_pmt_plan_id cn_role_pmt_plans.pmt_plan_id%TYPE,
1373: l_start_date cn_role_pmt_plans.start_date%TYPE,

Line 1371: CURSOR l_cur(l_role_id cn_role_pmt_plans.role_id%TYPE,

1367: p_end_date IN DATE,
1368: p_org_id IN NUMBER
1369: ) RETURN cn_role_pmt_plans.role_pmt_plan_id%TYPE IS
1370:
1371: CURSOR l_cur(l_role_id cn_role_pmt_plans.role_id%TYPE,
1372: l_pmt_plan_id cn_role_pmt_plans.pmt_plan_id%TYPE,
1373: l_start_date cn_role_pmt_plans.start_date%TYPE,
1374: l_end_date cn_role_pmt_plans.end_date%TYPE) IS
1375: SELECT role_pmt_plan_id

Line 1372: l_pmt_plan_id cn_role_pmt_plans.pmt_plan_id%TYPE,

1368: p_org_id IN NUMBER
1369: ) RETURN cn_role_pmt_plans.role_pmt_plan_id%TYPE IS
1370:
1371: CURSOR l_cur(l_role_id cn_role_pmt_plans.role_id%TYPE,
1372: l_pmt_plan_id cn_role_pmt_plans.pmt_plan_id%TYPE,
1373: l_start_date cn_role_pmt_plans.start_date%TYPE,
1374: l_end_date cn_role_pmt_plans.end_date%TYPE) IS
1375: SELECT role_pmt_plan_id
1376: FROM cn_role_pmt_plans

Line 1373: l_start_date cn_role_pmt_plans.start_date%TYPE,

1369: ) RETURN cn_role_pmt_plans.role_pmt_plan_id%TYPE IS
1370:
1371: CURSOR l_cur(l_role_id cn_role_pmt_plans.role_id%TYPE,
1372: l_pmt_plan_id cn_role_pmt_plans.pmt_plan_id%TYPE,
1373: l_start_date cn_role_pmt_plans.start_date%TYPE,
1374: l_end_date cn_role_pmt_plans.end_date%TYPE) IS
1375: SELECT role_pmt_plan_id
1376: FROM cn_role_pmt_plans
1377: WHERE role_id = l_role_id AND

Line 1374: l_end_date cn_role_pmt_plans.end_date%TYPE) IS

1370:
1371: CURSOR l_cur(l_role_id cn_role_pmt_plans.role_id%TYPE,
1372: l_pmt_plan_id cn_role_pmt_plans.pmt_plan_id%TYPE,
1373: l_start_date cn_role_pmt_plans.start_date%TYPE,
1374: l_end_date cn_role_pmt_plans.end_date%TYPE) IS
1375: SELECT role_pmt_plan_id
1376: FROM cn_role_pmt_plans
1377: WHERE role_id = l_role_id AND
1378: pmt_plan_id = l_pmt_plan_id AND

Line 1376: FROM cn_role_pmt_plans

1372: l_pmt_plan_id cn_role_pmt_plans.pmt_plan_id%TYPE,
1373: l_start_date cn_role_pmt_plans.start_date%TYPE,
1374: l_end_date cn_role_pmt_plans.end_date%TYPE) IS
1375: SELECT role_pmt_plan_id
1376: FROM cn_role_pmt_plans
1377: WHERE role_id = l_role_id AND
1378: pmt_plan_id = l_pmt_plan_id AND
1379: start_date = l_start_date AND
1380: ((end_date = l_end_date) OR

Line 1384: l_role_id cn_role_pmt_plans.role_id%TYPE;

1380: ((end_date = l_end_date) OR
1381: (end_date IS NULL AND l_end_date IS NULL));
1382:
1383: l_rec l_cur%ROWTYPE;
1384: l_role_id cn_role_pmt_plans.role_id%TYPE;
1385: l_pmt_plan_id cn_role_pmt_plans.pmt_plan_id%TYPE;
1386:
1387: BEGIN
1388:

Line 1385: l_pmt_plan_id cn_role_pmt_plans.pmt_plan_id%TYPE;

1381: (end_date IS NULL AND l_end_date IS NULL));
1382:
1383: l_rec l_cur%ROWTYPE;
1384: l_role_id cn_role_pmt_plans.role_id%TYPE;
1385: l_pmt_plan_id cn_role_pmt_plans.pmt_plan_id%TYPE;
1386:
1387: BEGIN
1388:
1389: l_role_id := cn_api.get_role_id(p_role_name);