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_SALESREPS

Line 85: from cn_salesreps

81:
82: -- get resource start and end dates
83: select start_date_active, end_date_active
84: into l_res_start_date, l_res_end_date
85: from cn_salesreps
86: where salesrep_id = l_salesrep_id
87: and org_id = l_org_id;
88:
89: -- get intersection with resource start and end dates

Line 180: FROM cn_salesreps

176: -- cn_srp_periods in order to create cn_srp_period_quotas. It's also a
177: -- reasonable business requirement
178: SELECT start_date_active, end_date_active
179: INTO l_srp_start_date, l_srp_end_date
180: FROM cn_salesreps
181: WHERE salesrep_id = p_salesrep_id
182: AND org_id = p_org_id;
183:
184: IF l_srp_start_date IS NULL THEN

Line 1012: p_source_object_code => 'CN_SALESREPS',

1008: x_return_status => x_return_status,
1009: x_msg_count => x_msg_count,
1010: x_msg_data => x_msg_data,
1011: p_source_object_id => p_pmt_plan_assign_rec.salesrep_id,
1012: p_source_object_code => 'CN_SALESREPS',
1013: p_notes => l_note_msg,
1014: p_notes_detail => l_note_msg,
1015: p_note_type => 'CN_SYSGEN', -- for system generated
1016: x_jtf_note_id => x_note_id -- returned

Line 1604: p_source_object_code => 'CN_SALESREPS',

1600: x_return_status => x_return_status,
1601: x_msg_count => x_msg_count,
1602: x_msg_data => x_msg_data,
1603: p_source_object_id => spp_info.salesrep_id,
1604: p_source_object_code => 'CN_SALESREPS',
1605: p_notes => l_note_msg,
1606: p_notes_detail => l_note_msg,
1607: p_note_type => 'CN_SYSGEN', -- for system generated
1608: x_jtf_note_id => x_note_id -- returned

Line 1703: l_salesrep_id cn_salesreps.salesrep_id%TYPE;

1699: l_srp_pmt_plan_id cn_srp_pmt_plans.srp_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;

Line 1898: l_salesrep_id_old cn_salesreps.salesrep_id%TYPE;

1894: l_count NUMBER;
1895: l_count_srp_pmt_plan NUMBER;
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;

Line 1899: l_salesrep_id_new cn_salesreps.salesrep_id%TYPE;

1895: l_count_srp_pmt_plan NUMBER;
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;

Line 2260: l_salesrep_id cn_salesreps.salesrep_id%TYPE;

2256: l_srp_pmt_plan_id cn_srp_pmt_plans.srp_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;