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 1709: l_srp_start_date cn_srp_roles.start_date%TYPE;

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

Line 1751: from cn_srp_roles

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

Line 1905: l_srp_start_date_new cn_srp_roles.start_date%TYPE;

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

Line 1907: l_srp_end_date_new cn_srp_roles.end_date%TYPE;

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

Line 1951: from cn_srp_roles

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

Line 1991: from cn_srp_roles

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

Line 2240: l_srp_start_date cn_srp_roles.start_date%TYPE;

2236: l_min_amt cn_pmt_plans.minimum_amount%TYPE;
2237: l_max_amt cn_pmt_plans.maximum_amount%TYPE;
2238: l_pp_start_date cn_pmt_plans.start_date%TYPE;
2239: l_pp_end_date cn_pmt_plans.end_date%TYPE;
2240: l_srp_start_date cn_srp_roles.start_date%TYPE;
2241: l_srp_end_date cn_pmt_plans.end_date%TYPE;
2242: l_start_date cn_srp_pmt_plans.start_date%TYPE;
2243: l_end_date cn_srp_pmt_plans.start_date%TYPE;
2244: l_role_pp_start_date cn_role_pmt_plans.start_date%TYPE;