APPS.CN_API dependencies on CN_SRP_PAYEE_ASSIGNS

Line 1416: RETURN cn_srp_payee_assigns.srp_payee_assign_id%TYPE IS

1412: p_quota_id NUMBER,
1413: p_start_date DATE,
1414: p_end_date DATE,
1415: p_org_id NUMBER)
1416: RETURN cn_srp_payee_assigns.srp_payee_assign_id%TYPE IS
1417:
1418: CURSOR get_srp_payee_assign_id_curs IS
1419: SELECT srp_payee_assign_id
1420: FROM cn_srp_payee_assigns

Line 1420: FROM cn_srp_payee_assigns

1416: RETURN cn_srp_payee_assigns.srp_payee_assign_id%TYPE IS
1417:
1418: CURSOR get_srp_payee_assign_id_curs IS
1419: SELECT srp_payee_assign_id
1420: FROM cn_srp_payee_assigns
1421: WHERE payee_id = p_payee_id
1422: AND salesrep_id = p_salesrep_id
1423: AND org_id = p_org_id
1424: AND quota_id = p_quota_id

Line 1430: FROM cn_srp_payee_assigns

1426: AND end_date = p_end_date ;
1427:
1428: CURSOR get_srp_payee_assign_id_curs1 IS
1429: SELECT srp_payee_assign_id
1430: FROM cn_srp_payee_assigns
1431: WHERE payee_id = p_payee_id
1432: AND salesrep_id = p_salesrep_id
1433: AND org_id = p_org_id
1434: AND quota_id = p_quota_id

Line 1438: l_srp_payee_assign_id cn_srp_payee_assigns.srp_payee_assign_id%TYPE;

1434: AND quota_id = p_quota_id
1435: AND start_date = p_start_date
1436: AND end_date IS NULL ;
1437:
1438: l_srp_payee_assign_id cn_srp_payee_assigns.srp_payee_assign_id%TYPE;
1439:
1440: BEGIN
1441:
1442: IF p_end_date IS NOT NULL THEN

Line 3069: FROM cn_srp_payee_assigns cnspay, cn_period_statuses cnps

3065: BEGIN
3066: -- isPayee if assigned to srp in this period
3067: SELECT 1 INTO l_exist FROM dual WHERE EXISTS
3068: (SELECT 1
3069: FROM cn_srp_payee_assigns cnspay, cn_period_statuses cnps
3070: WHERE cnspay.payee_id = p_salesrep_id
3071: AND cnps.period_id = p_period_id
3072: AND cnps.org_id = p_org_id
3073: AND cnspay.org_id = p_org_id