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 905: l_name cn_pmt_plans.name%TYPE;

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

Line 962: from cn_pmt_plans_all

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

Line 1103: l_oldname cn_pmt_plans.name%TYPE;

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

Line 1104: l_newname cn_pmt_plans.name%TYPE;

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

Line 1192: from cn_pmt_plans_all

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

Line 1331: SELECT name INTO l_oldname FROM cn_pmt_plans_all

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

Line 1333: SELECT name INTO l_newname FROM cn_pmt_plans_all

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

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

1536: l_pmt_plan_assign_rec pmt_plan_assign_rec;
1537:
1538: CURSOR spp_info_cur IS
1539: 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
1540: from cn_srp_pmt_plans_all spp, cn_pmt_plans_all p, cn_role_pmt_plans_all rpp, cn_roles r
1541: where spp.srp_pmt_plan_id = p_srp_pmt_plan_id
1542: and spp.role_pmt_plan_id = rpp.role_pmt_plan_id(+)
1543: and spp.pmt_plan_id = p.pmt_plan_id
1544: and rpp.role_id = r.role_id(+);

Line 1704: l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE;

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

Line 1705: l_org_id cn_pmt_plans.org_id%TYPE;

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

Line 1706: l_min_amt cn_pmt_plans.minimum_amount%TYPE;

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

Line 1707: l_max_amt cn_pmt_plans.maximum_amount%TYPE;

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

Line 1708: l_pp_start_date cn_pmt_plans.start_date%TYPE;

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

Line 1709: l_pp_end_date cn_pmt_plans.end_date%TYPE;

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

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

Line 1747: from cn_pmt_plans

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

Line 1900: l_pmt_plan_id_new cn_pmt_plans.pmt_plan_id%TYPE;

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

Line 1901: l_org_id cn_pmt_plans.org_id%TYPE;

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

Line 1902: l_min_amt_new cn_pmt_plans.minimum_amount%TYPE;

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

Line 1903: l_max_amt_new cn_pmt_plans.maximum_amount%TYPE;

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

Line 1904: l_pp_start_date_new cn_pmt_plans.start_date%TYPE;

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

Line 1905: l_pp_end_date_new cn_pmt_plans.end_date%TYPE;

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

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

Line 1917: l_pgc cn_pmt_plans.payment_group_code%TYPE;

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

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

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

Line 1987: from cn_pmt_plans

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

Line 2003: FROM cn_srp_pmt_plans cspp, cn_pmt_plans cpp

1999: and ((l_pp_start_date_new between start_date and nvl(end_date,l_null_date))
2000: or (nvl(l_pp_end_date_new,l_null_date) between start_date and nvl(end_date,l_null_date)));
2001: */
2002: SELECT COUNT(*) INTO l_count_srp_pmt_plan
2003: FROM cn_srp_pmt_plans cspp, cn_pmt_plans cpp
2004: WHERE cspp.salesrep_id = l_salesrep_id_old
2005: AND ((l_pp_start_date_new BETWEEN cspp.start_date AND NVL(cspp.end_date,l_pp_start_date_new))
2006: 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)))
2007: AND cspp.pmt_plan_id = cpp.pmt_plan_id

Line 2261: l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE;

2257: l_loading_status VARCHAR2(2000);
2258:
2259: newrec CN_SRP_PMT_PLANS_PUB.srp_pmt_plans_rec_type;
2260: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
2261: l_pmt_plan_id cn_pmt_plans.pmt_plan_id%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;

Line 2262: l_min_amt cn_pmt_plans.minimum_amount%TYPE;

2258:
2259: newrec CN_SRP_PMT_PLANS_PUB.srp_pmt_plans_rec_type;
2260: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
2261: l_pmt_plan_id cn_pmt_plans.pmt_plan_id%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;

Line 2263: l_max_amt cn_pmt_plans.maximum_amount%TYPE;

2259: newrec CN_SRP_PMT_PLANS_PUB.srp_pmt_plans_rec_type;
2260: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
2261: l_pmt_plan_id cn_pmt_plans.pmt_plan_id%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;

Line 2264: l_pp_start_date cn_pmt_plans.start_date%TYPE;

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

Line 2265: l_pp_end_date cn_pmt_plans.end_date%TYPE;

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

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

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

2315: crpp.start_date, crpp.end_date, spp.srp_pmt_plan_id
2316: into l_start_date, l_end_date, l_salesrep_id,
2317: l_min_amt, l_max_amt,
2318: l_role_pp_start_date, l_role_pp_end_date, l_srp_pmt_plan_id
2319: from cn_srp_pmt_plans spp, cn_pmt_plans cpp, cn_role_pmt_plans crpp
2320: where spp.srp_role_id = p_srp_role_id
2321: AND spp.role_pmt_plan_id = crpp.role_pmt_plan_id --p_role_pmt_plan_id
2322: AND crpp.role_pmt_plan_id = p_role_pmt_plan_id
2323: AND cpp.pmt_plan_id = spp.pmt_plan_id;