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 912: from cn_roles r, cn_role_pmt_plans_all rpp

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

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

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

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

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

Line 1946: from cn_role_pmt_plans

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

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

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

Line 2244: l_role_pp_start_date cn_role_pmt_plans.start_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;
2246:
2247:
2248: CURSOR spp_csr( l_srp_pmt_plan_id NUMBER ) IS

Line 2245: l_role_pp_end_date cn_role_pmt_plans.end_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;
2246:
2247:
2248: CURSOR spp_csr( l_srp_pmt_plan_id NUMBER ) IS
2249: SELECT *

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;