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.

[Home] [Help]

APPS.CN_WKSHT_CT_UP_PUB dependencies on CN_SRP_PMT_PLANS

Line 36: cn_srp_pmt_plans_v ppa

32: SELECT pw.payment_worksheet_id,
33: pw.salesrep_id
34: FROM cn_payment_worksheets pw,
35: cn_payruns p,
36: cn_srp_pmt_plans_v ppa
37: WHERE ppa.salesrep_id = p_salesrep_id
38: and ppa.srp_pmt_plan_id = p_srp_pmt_asgn_id
39: and p.payrun_id = p_payrun_id
40: and p.pay_period_id = ppa.period_id

Line 56: AND EXISTS (SELECT 1 FROM cn_srp_pmt_plans ppa

52: AND ps.period_id = p.pay_period_id
53: AND pw.payrun_id = p.payrun_id
54: AND pw.quota_id IS NULL
55: AND p.status = 'UNPAID'
56: AND EXISTS (SELECT 1 FROM cn_srp_pmt_plans ppa
57: WHERE ppa.srp_pmt_plan_id = p_srp_pmt_asgn_id
58: AND ppa.salesrep_id = pw.salesrep_id
59: AND ppa.start_date <= ps.end_date
60: AND Nvl(ppa.end_date,ps.end_date) >= ps.start_date);

Line 218: oldrec CN_SRP_PMT_PLANS_PUB.srp_pmt_plans_rec_type;

214: ) IS
215:
216: l_api_name CONSTANT VARCHAR2(30) := 'Apply_Payment_Plan_Upd';
217: l_api_version CONSTANT NUMBER := 1.0;
218: oldrec CN_SRP_PMT_PLANS_PUB.srp_pmt_plans_rec_type;
219: newrec CN_SRP_PMT_PLANS_PUB.srp_pmt_plans_rec_type;
220:
221: --Bug 3670308 by Julia Huang on 6/4/04
222: CURSOR get_wksht IS

Line 219: newrec CN_SRP_PMT_PLANS_PUB.srp_pmt_plans_rec_type;

215:
216: l_api_name CONSTANT VARCHAR2(30) := 'Apply_Payment_Plan_Upd';
217: l_api_version CONSTANT NUMBER := 1.0;
218: oldrec CN_SRP_PMT_PLANS_PUB.srp_pmt_plans_rec_type;
219: newrec CN_SRP_PMT_PLANS_PUB.srp_pmt_plans_rec_type;
220:
221: --Bug 3670308 by Julia Huang on 6/4/04
222: CURSOR get_wksht IS
223: SELECT pw.payment_worksheet_id,

Line 234: AND EXISTS (SELECT 1 FROM cn_srp_pmt_plans ppa

230: AND pw.payrun_id = p.payrun_id
231: AND ps.org_id = p.org_id
232: AND pw.quota_id IS NULL
233: AND p.status = 'UNPAID'
234: AND EXISTS (SELECT 1 FROM cn_srp_pmt_plans ppa
235: WHERE ppa.srp_pmt_plan_id = p_srp_pmt_asgn_id
236: AND ppa.salesrep_id = pw.salesrep_id
237: AND ppa.start_date <= ps.end_date
238: AND Nvl(ppa.end_date,ps.end_date) >= ps.start_date);

Line 293: CN_SRP_PMT_PLANS_PUB.Update_Srp_Pmt_Plan

289: newrec.end_date := p_srp_pmt_plans_rec.end_date;
290:
291: x_loading_status := 'CN_UPDATED';
292:
293: CN_SRP_PMT_PLANS_PUB.Update_Srp_Pmt_Plan
294: ( p_api_version => p_api_version,
295: p_init_msg_list => p_init_msg_list,
296: p_commit => p_commit,
297: p_validation_level=> p_validation_level,

Line 416: newrec CN_SRP_PMT_PLANS_PUB.srp_pmt_plans_rec_type;

412: ) IS
413:
414: l_api_name CONSTANT VARCHAR2(30) := 'Apply_Payment_Plan_del';
415: l_api_version CONSTANT NUMBER := 1.0;
416: newrec CN_SRP_PMT_PLANS_PUB.srp_pmt_plans_rec_type;
417:
418: --Bug 3670308 by Julia Huang on 6/4/04
419: CURSOR get_wksht IS
420: SELECT pw.payment_worksheet_id,

Line 431: AND EXISTS (SELECT 1 FROM cn_srp_pmt_plans ppa

427: AND ps.org_id = p.org_id
428: AND pw.payrun_id = p.payrun_id
429: AND pw.quota_id IS NULL
430: AND p.status = 'UNPAID'
431: AND EXISTS (SELECT 1 FROM cn_srp_pmt_plans ppa
432: WHERE ppa.srp_pmt_plan_id = p_srp_pmt_asgn_id
433: AND ppa.salesrep_id = pw.salesrep_id
434: AND ppa.start_date <= ps.end_date
435: AND Nvl(ppa.end_date,ps.end_date) >= ps.start_date);

Line 516: CN_SRP_PMT_PLANS_PUB.Delete_Srp_Pmt_Plan

512: newrec.maximum_amount := p_srp_pmt_plans_rec.maximum_amount;
513: newrec.start_date := p_srp_pmt_plans_rec.start_date;
514: newrec.end_date := p_srp_pmt_plans_rec.end_date;
515:
516: CN_SRP_PMT_PLANS_PUB.Delete_Srp_Pmt_Plan
517: ( p_api_version => p_api_version,
518: p_init_msg_list => p_init_msg_list,
519: p_commit => p_commit,
520: p_validation_level=> p_validation_level,

Line 629: newrec CN_SRP_PMT_PLANS_PUB.srp_pmt_plans_rec_type;

625: ) IS
626:
627: l_api_name CONSTANT VARCHAR2(30) := 'Apply_Payment_Plan_del';
628: l_api_version CONSTANT NUMBER := 1.0;
629: newrec CN_SRP_PMT_PLANS_PUB.srp_pmt_plans_rec_type;
630:
631: --Bug 3670308 by Julia Huang on 6/4/04
632: CURSOR get_wksht IS
633: /*

Line 638: cn_srp_pmt_plans_v ppa

634: SELECT pw.payment_worksheet_id,
635: pw.salesrep_id
636: FROM cn_payment_worksheets pw,
637: cn_payruns p,
638: cn_srp_pmt_plans_v ppa
639: WHERE ppa.salesrep_id = p_salesrep_id
640: and ppa.srp_pmt_plan_id = p_srp_pmt_asgn_id
641: and p.payrun_id = p_payrun_id
642: and p.pay_period_id = ppa.period_id

Line 659: AND EXISTS (SELECT 1 FROM cn_srp_pmt_plans ppa

655: AND ps.org_id = p.org_id
656: AND pw.payrun_id = p.payrun_id
657: AND pw.quota_id IS NULL
658: AND p.status = 'UNPAID'
659: AND EXISTS (SELECT 1 FROM cn_srp_pmt_plans ppa
660: WHERE ppa.srp_pmt_plan_id = p_srp_pmt_asgn_id
661: AND ppa.salesrep_id = pw.salesrep_id
662: AND ppa.start_date <= ps.end_date
663: AND Nvl(ppa.end_date,ps.end_date) >= ps.start_date);

Line 746: CN_SRP_PMT_PLANS_PUB.Create_Srp_Pmt_Plan

742: newrec.maximum_amount := p_srp_pmt_plans_rec.maximum_amount;
743: newrec.start_date := p_srp_pmt_plans_rec.start_date;
744: newrec.end_date := p_srp_pmt_plans_rec.end_date;
745:
746: CN_SRP_PMT_PLANS_PUB.Create_Srp_Pmt_Plan
747: ( p_api_version => p_api_version,
748: p_init_msg_list => p_init_msg_list,
749: p_commit => p_commit,
750: p_validation_level=> p_validation_level,