APPS.CN_SRP_PMT_PLANS_PVT dependencies on CN_SRP_ROLES

Line 66: from cn_srp_roles

62:
63: -- get srp role assignment start and end dates
64: select start_date, end_date, salesrep_id
65: into l_srp_role_start_date, l_srp_role_end_date, l_salesrep_id
66: from cn_srp_roles
67: where srp_role_id = p_srp_role_id
68: and org_id = l_org_id;
69:
70: -- get intersection between srp_role and role_payment_plan dates

Line 1710: l_srp_start_date cn_srp_roles.start_date%TYPE;

1706: l_min_amt cn_pmt_plans.minimum_amount%TYPE;
1707: l_max_amt cn_pmt_plans.maximum_amount%TYPE;
1708: l_pp_start_date cn_pmt_plans.start_date%TYPE;
1709: l_pp_end_date cn_pmt_plans.end_date%TYPE;
1710: l_srp_start_date cn_srp_roles.start_date%TYPE;
1711: l_srp_end_date cn_pmt_plans.end_date%TYPE;
1712: l_start_date cn_srp_pmt_plans.start_date%TYPE;
1713: l_end_date cn_srp_pmt_plans.start_date%TYPE;
1714:

Line 1752: from cn_srp_roles

1748: where pmt_plan_id = l_pmt_plan_id;
1749:
1750: select salesrep_id, start_date, end_date
1751: into l_salesrep_id, l_srp_start_date, l_srp_end_date
1752: from cn_srp_roles
1753: where srp_role_id = p_srp_role_id
1754: and org_id = l_org_id;
1755:
1756: l_start_date := NULL;

Line 1906: l_srp_start_date_new cn_srp_roles.start_date%TYPE;

1902: l_min_amt_new cn_pmt_plans.minimum_amount%TYPE;
1903: l_max_amt_new cn_pmt_plans.maximum_amount%TYPE;
1904: l_pp_start_date_new cn_pmt_plans.start_date%TYPE;
1905: l_pp_end_date_new cn_pmt_plans.end_date%TYPE;
1906: l_srp_start_date_new cn_srp_roles.start_date%TYPE;
1907: --l_srp_end_date_new cn_pmt_plans.end_date%TYPE;
1908: l_srp_end_date_new cn_srp_roles.end_date%TYPE;
1909: l_start_date_old cn_srp_pmt_plans.start_date%TYPE;
1910: l_start_date_new cn_srp_pmt_plans.start_date%TYPE;

Line 1908: l_srp_end_date_new cn_srp_roles.end_date%TYPE;

1904: l_pp_start_date_new cn_pmt_plans.start_date%TYPE;
1905: l_pp_end_date_new cn_pmt_plans.end_date%TYPE;
1906: l_srp_start_date_new cn_srp_roles.start_date%TYPE;
1907: --l_srp_end_date_new cn_pmt_plans.end_date%TYPE;
1908: l_srp_end_date_new cn_srp_roles.end_date%TYPE;
1909: l_start_date_old cn_srp_pmt_plans.start_date%TYPE;
1910: l_start_date_new cn_srp_pmt_plans.start_date%TYPE;
1911: l_end_date_old cn_srp_pmt_plans.start_date%TYPE;
1912: l_end_date_new cn_srp_pmt_plans.start_date%TYPE;

Line 1952: from cn_srp_roles

1948: where role_pmt_plan_id = p_role_pmt_plan_id;
1949:
1950: select salesrep_id
1951: into l_salesrep_id_old
1952: from cn_srp_roles
1953: where srp_role_id = p_srp_role_id
1954: and org_id = l_org_id;
1955:
1956: --Added to check if the role_pay_group_id is existing in cn_srp_pmt_plans

Line 1992: from cn_srp_roles

1988: where pmt_plan_id = l_pmt_plan_id_new;
1989:
1990: select salesrep_id, start_date, end_date
1991: into l_salesrep_id_new, l_srp_start_date_new, l_srp_end_date_new
1992: from cn_srp_roles
1993: where srp_role_id = p_srp_role_id
1994: and org_id = l_org_id;
1995:
1996: --Added to check if the a record exists in cn_srp_pmt_plans for the dates passed for bug 3147026

Line 2266: l_srp_start_date cn_srp_roles.start_date%TYPE;

2262: l_min_amt cn_pmt_plans.minimum_amount%TYPE;
2263: l_max_amt cn_pmt_plans.maximum_amount%TYPE;
2264: l_pp_start_date cn_pmt_plans.start_date%TYPE;
2265: l_pp_end_date cn_pmt_plans.end_date%TYPE;
2266: l_srp_start_date cn_srp_roles.start_date%TYPE;
2267: l_srp_end_date cn_pmt_plans.end_date%TYPE;
2268: l_start_date cn_srp_pmt_plans.start_date%TYPE;
2269: l_end_date cn_srp_pmt_plans.start_date%TYPE;
2270: l_role_pp_start_date cn_role_pmt_plans.start_date%TYPE;