APPS.CN_API dependencies on CN_ROLE_PMT_PLANS

Line 1347: ) RETURN cn_role_pmt_plans.role_pmt_plan_id%TYPE IS

1343: p_pmt_plan_name IN VARCHAR2,
1344: p_start_date IN DATE,
1345: p_end_date IN DATE,
1346: p_org_id IN NUMBER
1347: ) RETURN cn_role_pmt_plans.role_pmt_plan_id%TYPE IS
1348:
1349: CURSOR l_cur(l_role_id cn_role_pmt_plans.role_id%TYPE,
1350: l_pmt_plan_id cn_role_pmt_plans.pmt_plan_id%TYPE,
1351: l_start_date cn_role_pmt_plans.start_date%TYPE,

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

1345: p_end_date IN DATE,
1346: p_org_id IN NUMBER
1347: ) RETURN cn_role_pmt_plans.role_pmt_plan_id%TYPE IS
1348:
1349: CURSOR l_cur(l_role_id cn_role_pmt_plans.role_id%TYPE,
1350: l_pmt_plan_id cn_role_pmt_plans.pmt_plan_id%TYPE,
1351: l_start_date cn_role_pmt_plans.start_date%TYPE,
1352: l_end_date cn_role_pmt_plans.end_date%TYPE) IS
1353: SELECT role_pmt_plan_id

Line 1350: l_pmt_plan_id cn_role_pmt_plans.pmt_plan_id%TYPE,

1346: p_org_id IN NUMBER
1347: ) RETURN cn_role_pmt_plans.role_pmt_plan_id%TYPE IS
1348:
1349: CURSOR l_cur(l_role_id cn_role_pmt_plans.role_id%TYPE,
1350: l_pmt_plan_id cn_role_pmt_plans.pmt_plan_id%TYPE,
1351: l_start_date cn_role_pmt_plans.start_date%TYPE,
1352: l_end_date cn_role_pmt_plans.end_date%TYPE) IS
1353: SELECT role_pmt_plan_id
1354: FROM cn_role_pmt_plans

Line 1351: l_start_date cn_role_pmt_plans.start_date%TYPE,

1347: ) RETURN cn_role_pmt_plans.role_pmt_plan_id%TYPE IS
1348:
1349: CURSOR l_cur(l_role_id cn_role_pmt_plans.role_id%TYPE,
1350: l_pmt_plan_id cn_role_pmt_plans.pmt_plan_id%TYPE,
1351: l_start_date cn_role_pmt_plans.start_date%TYPE,
1352: l_end_date cn_role_pmt_plans.end_date%TYPE) IS
1353: SELECT role_pmt_plan_id
1354: FROM cn_role_pmt_plans
1355: WHERE role_id = l_role_id AND

Line 1352: l_end_date cn_role_pmt_plans.end_date%TYPE) IS

1348:
1349: CURSOR l_cur(l_role_id cn_role_pmt_plans.role_id%TYPE,
1350: l_pmt_plan_id cn_role_pmt_plans.pmt_plan_id%TYPE,
1351: l_start_date cn_role_pmt_plans.start_date%TYPE,
1352: l_end_date cn_role_pmt_plans.end_date%TYPE) IS
1353: SELECT role_pmt_plan_id
1354: FROM cn_role_pmt_plans
1355: WHERE role_id = l_role_id AND
1356: pmt_plan_id = l_pmt_plan_id AND

Line 1354: FROM cn_role_pmt_plans

1350: l_pmt_plan_id cn_role_pmt_plans.pmt_plan_id%TYPE,
1351: l_start_date cn_role_pmt_plans.start_date%TYPE,
1352: l_end_date cn_role_pmt_plans.end_date%TYPE) IS
1353: SELECT role_pmt_plan_id
1354: FROM cn_role_pmt_plans
1355: WHERE role_id = l_role_id AND
1356: pmt_plan_id = l_pmt_plan_id AND
1357: start_date = l_start_date AND
1358: ((end_date = l_end_date) OR

Line 1362: l_role_id cn_role_pmt_plans.role_id%TYPE;

1358: ((end_date = l_end_date) OR
1359: (end_date IS NULL AND l_end_date IS NULL));
1360:
1361: l_rec l_cur%ROWTYPE;
1362: l_role_id cn_role_pmt_plans.role_id%TYPE;
1363: l_pmt_plan_id cn_role_pmt_plans.pmt_plan_id%TYPE;
1364:
1365: BEGIN
1366:

Line 1363: l_pmt_plan_id cn_role_pmt_plans.pmt_plan_id%TYPE;

1359: (end_date IS NULL AND l_end_date IS NULL));
1360:
1361: l_rec l_cur%ROWTYPE;
1362: l_role_id cn_role_pmt_plans.role_id%TYPE;
1363: l_pmt_plan_id cn_role_pmt_plans.pmt_plan_id%TYPE;
1364:
1365: BEGIN
1366:
1367: l_role_id := cn_api.get_role_id(p_role_name);