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_ROLE_PMT_PLANS

Line 60: from cn_role_pmt_plans

56: BEGIN
57: -- get start_date, end_date org_id and pmt_plan_id from role_pmt_plans
58: select org_id, pmt_plan_id, start_date, end_date
59: into l_org_id, l_pmt_plan_id, l_role_pp_start_date, l_role_pp_end_date
60: from cn_role_pmt_plans
61: where ROLE_PMT_PLAN_ID = p_role_pmt_plan_id;
62:
63: -- get srp role assignment start and end dates
64: select start_date, end_date, salesrep_id

Line 913: from cn_roles r, cn_role_pmt_plans_all rpp

909: l_note_msg VARCHAR2(240);
910:
911: CURSOR get_role_name IS
912: select r.name
913: from cn_roles r, cn_role_pmt_plans_all rpp
914: where r.role_id = rpp.role_id
915: and rpp.role_pmt_plan_id = p_pmt_plan_assign_rec.role_pmt_plan_id;
916:
917: BEGIN

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 1742: from cn_role_pmt_plans

1738: x_loading_status := 'CN_PP_CREATED';
1739:
1740: select pmt_plan_id, start_date, end_date
1741: into l_pmt_plan_id, l_pp_start_date, l_pp_end_date
1742: from cn_role_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

Line 1913: l_role_pp_start_date cn_role_pmt_plans.start_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;
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;

Line 1914: l_role_pp_end_date cn_role_pmt_plans.end_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;
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;

Line 1947: from cn_role_pmt_plans

1943: x_return_status := FND_API.G_RET_STS_SUCCESS;
1944: x_loading_status := 'CN_PP_UPDATED';
1945:
1946: select org_id into l_org_id
1947: from cn_role_pmt_plans
1948: where role_pmt_plan_id = p_role_pmt_plan_id;
1949:
1950: select salesrep_id
1951: into l_salesrep_id_old

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 1981: from cn_role_pmt_plans

1977: END IF;
1978:
1979: select pmt_plan_id, start_date, end_date
1980: into l_pmt_plan_id_new, l_pp_start_date_new, l_pp_end_date_new
1981: from cn_role_pmt_plans
1982: where role_pmt_plan_id = p_role_pmt_plan_id;
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

Line 2270: l_role_pp_start_date cn_role_pmt_plans.start_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;
2272:
2273:
2274: CURSOR spp_csr( l_srp_pmt_plan_id NUMBER ) IS

Line 2271: l_role_pp_end_date cn_role_pmt_plans.end_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;
2272:
2273:
2274: CURSOR spp_csr( l_srp_pmt_plan_id NUMBER ) IS
2275: SELECT *

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;