eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_SRP_PMT_PLANS_PVT dependencies on CN_PMT_PLANS

Line 104: from cn_pmt_plans

100:
101: -- get payment plan start and end dates
102: select start_date, end_date
103: into l_pp_start_date, l_pp_end_date
104: from cn_pmt_plans
105: where pmt_plan_id = l_pmt_plan_id;
106:
107: -- get intersection with payment plan start and end dates
108: get_date_range_intersect(

Line 253: FROM cn_pmt_plans_all

249: --
250:
251: SELECT start_date, end_date, payment_group_code
252: INTO l_pp_start_date, l_pp_end_date, l_payment_group_code
253: FROM cn_pmt_plans_all
254: WHERE pmt_plan_id = p_pmt_plan_id;
255: IF ( (
256: ( l_pp_start_date IS NOT NULL) AND ( l_pp_end_date IS NOT NULL)
257: AND(

Line 286: FROM cn_srp_pmt_plans_all cspp, cn_pmt_plans_all cpp

282: -- Ensure pmt plan assignments do not overlap each other in same role
283: -- only 1 payment plan is active at each date
284: -- Returns an error message and raises an exception if overlap occurs.
285: SELECT COUNT(1) INTO l_dummy
286: FROM cn_srp_pmt_plans_all cspp, cn_pmt_plans_all cpp
287: WHERE (((cspp.end_date IS NULL)
288: AND (p_end_date IS NULL))
289: OR
290: ((cspp.end_date IS NULL) AND

Line 415: cn_payruns_all prun, cn_srp_pmt_plans_all spp,cn_pmt_plans_all pp

411:
412: CURSOR get_paid_del_payruns IS
413: SELECT 'ERROR' as estatus
414: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,
415: cn_payruns_all prun, cn_srp_pmt_plans_all spp,cn_pmt_plans_all pp
416: WHERE w.salesrep_id = spp.salesrep_id
417: AND w.quota_id is null
418: AND prun.pay_period_id = prd.period_id
419: AND prun.org_id = prd.org_id

Line 435: cn_payruns_all prun, cn_srp_pmt_plans_all spp,cn_pmt_plans_all pp

431:
432: CURSOR get_adj_del_payruns IS
433: SELECT 'ERROR' as estatus
434: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,
435: cn_payruns_all prun, cn_srp_pmt_plans_all spp,cn_pmt_plans_all pp
436: -- cn_payment_transactions pt
437: WHERE w.salesrep_id = spp.salesrep_id
438: AND w.quota_id is null
439: AND prun.pay_period_id = prd.period_id

Line 904: l_name cn_pmt_plans.name%TYPE;

900:
901: l_api_name CONSTANT VARCHAR2(30) := 'Create_Srp_Pmt_Plan';
902: l_api_version CONSTANT NUMBER := 1.0;
903: l_credit_type_id NUMBER;
904: l_name cn_pmt_plans.name%TYPE;
905: l_role_name cn_roles.name%TYPE;
906: l_loading_status VARCHAR2(2000);
907: x_note_id NUMBER;
908: l_note_msg VARCHAR2(240);

Line 961: from cn_pmt_plans_all

957: END IF;
958:
959: -- inherit credit type of pmt plan
960: select credit_type_id, name into l_credit_type_id, l_name
961: from cn_pmt_plans_all
962: where pmt_plan_id = p_pmt_plan_assign_rec.pmt_plan_id;
963:
964:
965: cn_srp_pmt_plans_pkg.insert_row

Line 1102: l_oldname cn_pmt_plans.name%TYPE;

1098: FROM cn_srp_pmt_plans
1099: WHERE srp_pmt_plan_id = l_srp_pmt_plan_id;
1100:
1101: l_oldrec spp_csr%ROWTYPE;
1102: l_oldname cn_pmt_plans.name%TYPE;
1103: l_newname cn_pmt_plans.name%TYPE;
1104: l_notemsg VARCHAR2(2000);
1105:
1106:

Line 1103: l_newname cn_pmt_plans.name%TYPE;

1099: WHERE srp_pmt_plan_id = l_srp_pmt_plan_id;
1100:
1101: l_oldrec spp_csr%ROWTYPE;
1102: l_oldname cn_pmt_plans.name%TYPE;
1103: l_newname cn_pmt_plans.name%TYPE;
1104: l_notemsg VARCHAR2(2000);
1105:
1106:
1107: BEGIN

Line 1191: from cn_pmt_plans_all

1187: x_loading_status => x_loading_status);
1188:
1189: -- inherit credit type of pmt plan
1190: select credit_type_id into l_credit_type_id
1191: from cn_pmt_plans_all
1192: where pmt_plan_id = p_pmt_plan_assign_rec.pmt_plan_id;
1193:
1194: -- if the lock_flag is being set, then blow away role_pmt_plan_id
1195: IF p_pmt_plan_assign_rec.lock_flag = 'Y' THEN

Line 1330: SELECT name INTO l_oldname FROM cn_pmt_plans_all

1326: l_notemsg := NULL;
1327:
1328: -- raise notes
1329: IF l_oldrec.pmt_plan_id <> p_pmt_plan_assign_rec.pmt_plan_id THEN
1330: SELECT name INTO l_oldname FROM cn_pmt_plans_all
1331: WHERE pmt_plan_id = l_oldrec.pmt_plan_id;
1332: SELECT name INTO l_newname FROM cn_pmt_plans_all
1333: WHERE pmt_plan_id = p_pmt_plan_assign_rec.pmt_plan_id;
1334: get_note('PMT_PLAN', l_oldname, l_newname, l_notemsg);

Line 1332: SELECT name INTO l_newname FROM cn_pmt_plans_all

1328: -- raise notes
1329: IF l_oldrec.pmt_plan_id <> p_pmt_plan_assign_rec.pmt_plan_id THEN
1330: SELECT name INTO l_oldname FROM cn_pmt_plans_all
1331: WHERE pmt_plan_id = l_oldrec.pmt_plan_id;
1332: SELECT name INTO l_newname FROM cn_pmt_plans_all
1333: WHERE pmt_plan_id = p_pmt_plan_assign_rec.pmt_plan_id;
1334: get_note('PMT_PLAN', l_oldname, l_newname, l_notemsg);
1335: END IF;
1336:

Line 1539: from cn_srp_pmt_plans_all spp, cn_pmt_plans_all p, cn_role_pmt_plans_all rpp, cn_roles r

1535: l_pmt_plan_assign_rec pmt_plan_assign_rec;
1536:
1537: CURSOR spp_info_cur IS
1538: select p.name, r.name role_name, spp.start_date, spp.end_date, spp.minimum_amount, spp.maximum_amount, spp.lock_flag, spp.salesrep_id
1539: from cn_srp_pmt_plans_all spp, cn_pmt_plans_all p, cn_role_pmt_plans_all rpp, cn_roles r
1540: where spp.srp_pmt_plan_id = p_srp_pmt_plan_id
1541: and spp.role_pmt_plan_id = rpp.role_pmt_plan_id(+)
1542: and spp.pmt_plan_id = p.pmt_plan_id
1543: and rpp.role_id = r.role_id(+);

Line 1703: l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE;

1699: l_loading_status VARCHAR2(2000);
1700:
1701: newrec pmt_plan_assign_rec;
1702: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
1703: l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE;
1704: l_org_id cn_pmt_plans.org_id%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;

Line 1704: l_org_id cn_pmt_plans.org_id%TYPE;

1700:
1701: newrec pmt_plan_assign_rec;
1702: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
1703: l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE;
1704: l_org_id cn_pmt_plans.org_id%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;

Line 1705: l_min_amt cn_pmt_plans.minimum_amount%TYPE;

1701: newrec pmt_plan_assign_rec;
1702: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
1703: l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE;
1704: l_org_id cn_pmt_plans.org_id%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;

Line 1706: l_max_amt cn_pmt_plans.maximum_amount%TYPE;

1702: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
1703: l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE;
1704: l_org_id cn_pmt_plans.org_id%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;

Line 1707: l_pp_start_date cn_pmt_plans.start_date%TYPE;

1703: l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE;
1704: l_org_id cn_pmt_plans.org_id%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;

Line 1708: l_pp_end_date cn_pmt_plans.end_date%TYPE;

1704: l_org_id cn_pmt_plans.org_id%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;

Line 1710: l_srp_end_date cn_pmt_plans.end_date%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:
1714: BEGIN

Line 1746: from cn_pmt_plans

1742: where role_pmt_plan_id = p_role_pmt_plan_id;
1743:
1744: select minimum_amount, maximum_amount, org_id
1745: into l_min_amt, l_max_amt, l_org_id
1746: from cn_pmt_plans
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

Line 1899: l_pmt_plan_id_new cn_pmt_plans.pmt_plan_id%TYPE;

1895:
1896: newrec pmt_plan_assign_rec;
1897: l_salesrep_id_old cn_salesreps.salesrep_id%TYPE;
1898: l_salesrep_id_new cn_salesreps.salesrep_id%TYPE;
1899: l_pmt_plan_id_new cn_pmt_plans.pmt_plan_id%TYPE;
1900: l_org_id cn_pmt_plans.org_id%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;

Line 1900: l_org_id cn_pmt_plans.org_id%TYPE;

1896: newrec pmt_plan_assign_rec;
1897: l_salesrep_id_old cn_salesreps.salesrep_id%TYPE;
1898: l_salesrep_id_new cn_salesreps.salesrep_id%TYPE;
1899: l_pmt_plan_id_new cn_pmt_plans.pmt_plan_id%TYPE;
1900: l_org_id cn_pmt_plans.org_id%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;

Line 1901: l_min_amt_new cn_pmt_plans.minimum_amount%TYPE;

1897: l_salesrep_id_old cn_salesreps.salesrep_id%TYPE;
1898: l_salesrep_id_new cn_salesreps.salesrep_id%TYPE;
1899: l_pmt_plan_id_new cn_pmt_plans.pmt_plan_id%TYPE;
1900: l_org_id cn_pmt_plans.org_id%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;

Line 1902: l_max_amt_new cn_pmt_plans.maximum_amount%TYPE;

1898: l_salesrep_id_new cn_salesreps.salesrep_id%TYPE;
1899: l_pmt_plan_id_new cn_pmt_plans.pmt_plan_id%TYPE;
1900: l_org_id cn_pmt_plans.org_id%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;

Line 1903: l_pp_start_date_new cn_pmt_plans.start_date%TYPE;

1899: l_pmt_plan_id_new cn_pmt_plans.pmt_plan_id%TYPE;
1900: l_org_id cn_pmt_plans.org_id%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;

Line 1904: l_pp_end_date_new cn_pmt_plans.end_date%TYPE;

1900: l_org_id cn_pmt_plans.org_id%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;

Line 1906: --l_srp_end_date_new cn_pmt_plans.end_date%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;
1910: l_end_date_old cn_srp_pmt_plans.start_date%TYPE;

Line 1916: l_pgc cn_pmt_plans.payment_group_code%TYPE;

1912: l_role_pp_start_date cn_role_pmt_plans.start_date%TYPE;
1913: l_role_pp_end_date cn_role_pmt_plans.end_date%TYPE;
1914:
1915: --Added payment group code for bug 3560026 by Julia Huang on 4/7/2004.
1916: l_pgc cn_pmt_plans.payment_group_code%TYPE;
1917: l_worksheets NUMBER;
1918: l_end_of_time CONSTANT DATE := To_date('31-12-9999', 'DD-MM-YYYY');
1919:
1920: BEGIN

Line 1970: from cn_srp_pmt_plans_all spp, cn_pmt_plans_all cpp, cn_role_pmt_plans_all crpp

1966: select spp.start_date, spp.end_date, spp.salesrep_id,
1967: crpp.start_date, crpp.end_date, spp.srp_pmt_plan_id
1968: into l_start_date_old, l_end_date_old, l_salesrep_id_old,
1969: l_role_pp_start_date, l_role_pp_end_date, l_srp_pmt_plan_id
1970: from cn_srp_pmt_plans_all spp, cn_pmt_plans_all cpp, cn_role_pmt_plans_all crpp
1971: where spp.srp_role_id = p_srp_role_id
1972: AND spp.role_pmt_plan_id = crpp.role_pmt_plan_id --p_role_pmt_plan_id
1973: AND crpp.role_pmt_plan_id = p_role_pmt_plan_id
1974: AND cpp.pmt_plan_id = spp.pmt_plan_id;

Line 1986: from cn_pmt_plans

1982:
1983: --Added payment group code for bug 3560026 by Julia Huang on 4/7/2004.
1984: select minimum_amount, maximum_amount, payment_group_code, org_id
1985: into l_min_amt_new, l_max_amt_new, l_pgc, l_org_id
1986: from cn_pmt_plans
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

Line 2002: FROM cn_srp_pmt_plans cspp, cn_pmt_plans cpp

1998: and ((l_pp_start_date_new between start_date and nvl(end_date,l_null_date))
1999: or (nvl(l_pp_end_date_new,l_null_date) between start_date and nvl(end_date,l_null_date)));
2000: */
2001: SELECT COUNT(*) INTO l_count_srp_pmt_plan
2002: FROM cn_srp_pmt_plans cspp, cn_pmt_plans cpp
2003: WHERE cspp.salesrep_id = l_salesrep_id_old
2004: AND ((l_pp_start_date_new BETWEEN cspp.start_date AND NVL(cspp.end_date,l_pp_start_date_new))
2005: OR (NVL(l_pp_end_date_new,l_pp_start_date_new) BETWEEN cspp.start_date AND NVL(cspp.end_date,l_pp_end_date_new)))
2006: AND cspp.pmt_plan_id = cpp.pmt_plan_id

Line 2235: l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE;

2231: l_loading_status VARCHAR2(2000);
2232:
2233: newrec CN_SRP_PMT_PLANS_PUB.srp_pmt_plans_rec_type;
2234: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
2235: l_pmt_plan_id cn_pmt_plans.pmt_plan_id%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;

Line 2236: l_min_amt cn_pmt_plans.minimum_amount%TYPE;

2232:
2233: newrec CN_SRP_PMT_PLANS_PUB.srp_pmt_plans_rec_type;
2234: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
2235: l_pmt_plan_id cn_pmt_plans.pmt_plan_id%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;

Line 2237: l_max_amt cn_pmt_plans.maximum_amount%TYPE;

2233: newrec CN_SRP_PMT_PLANS_PUB.srp_pmt_plans_rec_type;
2234: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
2235: l_pmt_plan_id cn_pmt_plans.pmt_plan_id%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;

Line 2238: l_pp_start_date cn_pmt_plans.start_date%TYPE;

2234: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
2235: l_pmt_plan_id cn_pmt_plans.pmt_plan_id%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;

Line 2239: l_pp_end_date cn_pmt_plans.end_date%TYPE;

2235: l_pmt_plan_id cn_pmt_plans.pmt_plan_id%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;

Line 2241: l_srp_end_date cn_pmt_plans.end_date%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;
2245: l_role_pp_end_date cn_role_pmt_plans.end_date%TYPE;

Line 2293: from cn_srp_pmt_plans spp, cn_pmt_plans cpp, cn_role_pmt_plans crpp

2289: crpp.start_date, crpp.end_date, spp.srp_pmt_plan_id
2290: into l_start_date, l_end_date, l_salesrep_id,
2291: l_min_amt, l_max_amt,
2292: l_role_pp_start_date, l_role_pp_end_date, l_srp_pmt_plan_id
2293: from cn_srp_pmt_plans spp, cn_pmt_plans cpp, cn_role_pmt_plans crpp
2294: where spp.srp_role_id = p_srp_role_id
2295: AND spp.role_pmt_plan_id = crpp.role_pmt_plan_id --p_role_pmt_plan_id
2296: AND crpp.role_pmt_plan_id = p_role_pmt_plan_id
2297: AND cpp.pmt_plan_id = spp.pmt_plan_id;