APPS.CN_API dependencies on CN_SRP_PAYEE_ASSIGNS

Line 1394: RETURN cn_srp_payee_assigns.srp_payee_assign_id%TYPE IS

1390: p_quota_id NUMBER,
1391: p_start_date DATE,
1392: p_end_date DATE,
1393: p_org_id NUMBER)
1394: RETURN cn_srp_payee_assigns.srp_payee_assign_id%TYPE IS
1395:
1396: CURSOR get_srp_payee_assign_id_curs IS
1397: SELECT srp_payee_assign_id
1398: FROM cn_srp_payee_assigns

Line 1398: FROM cn_srp_payee_assigns

1394: RETURN cn_srp_payee_assigns.srp_payee_assign_id%TYPE IS
1395:
1396: CURSOR get_srp_payee_assign_id_curs IS
1397: SELECT srp_payee_assign_id
1398: FROM cn_srp_payee_assigns
1399: WHERE payee_id = p_payee_id
1400: AND salesrep_id = p_salesrep_id
1401: AND org_id = p_org_id
1402: AND quota_id = p_quota_id

Line 1408: FROM cn_srp_payee_assigns

1404: AND end_date = p_end_date ;
1405:
1406: CURSOR get_srp_payee_assign_id_curs1 IS
1407: SELECT srp_payee_assign_id
1408: FROM cn_srp_payee_assigns
1409: WHERE payee_id = p_payee_id
1410: AND salesrep_id = p_salesrep_id
1411: AND org_id = p_org_id
1412: AND quota_id = p_quota_id

Line 1416: l_srp_payee_assign_id cn_srp_payee_assigns.srp_payee_assign_id%TYPE;

1412: AND quota_id = p_quota_id
1413: AND start_date = p_start_date
1414: AND end_date IS NULL ;
1415:
1416: l_srp_payee_assign_id cn_srp_payee_assigns.srp_payee_assign_id%TYPE;
1417:
1418: BEGIN
1419:
1420: IF p_end_date IS NOT NULL THEN

Line 3047: FROM cn_srp_payee_assigns cnspay, cn_period_statuses cnps

3043: BEGIN
3044: -- isPayee if assigned to srp in this period
3045: SELECT 1 INTO l_exist FROM dual WHERE EXISTS
3046: (SELECT 1
3047: FROM cn_srp_payee_assigns cnspay, cn_period_statuses cnps
3048: WHERE cnspay.payee_id = p_salesrep_id
3049: AND cnps.period_id = p_period_id
3050: AND cnps.org_id = p_org_id
3051: AND cnspay.org_id = p_org_id