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_PAYMENT_WORKSHEET_PVT dependencies on CN_PERIOD_STATUSES

Line 150: p_period_id IN cn_period_statuses.period_id%TYPE,

146: -- Calls :
147: -- ===========================================================================
148: PROCEDURE get_pay_rec_period_ids
149: (
150: p_period_id IN cn_period_statuses.period_id%TYPE,
151: p_quarter_num IN cn_period_statuses.quarter_num%TYPE,
152: p_period_year IN cn_period_statuses.period_year%TYPE,
153: p_pay_interval_type_id IN cn_pmt_plans.pay_interval_type_id%TYPE,
154: p_recoverable_interval_type_id IN cn_pmt_plans.recoverable_interval_type_id%TYPE,

Line 151: p_quarter_num IN cn_period_statuses.quarter_num%TYPE,

147: -- ===========================================================================
148: PROCEDURE get_pay_rec_period_ids
149: (
150: p_period_id IN cn_period_statuses.period_id%TYPE,
151: p_quarter_num IN cn_period_statuses.quarter_num%TYPE,
152: p_period_year IN cn_period_statuses.period_year%TYPE,
153: p_pay_interval_type_id IN cn_pmt_plans.pay_interval_type_id%TYPE,
154: p_recoverable_interval_type_id IN cn_pmt_plans.recoverable_interval_type_id%TYPE,
155: x_pay_period_id OUT NOCOPY cn_pmt_plans.pay_interval_type_id%TYPE,

Line 152: p_period_year IN cn_period_statuses.period_year%TYPE,

148: PROCEDURE get_pay_rec_period_ids
149: (
150: p_period_id IN cn_period_statuses.period_id%TYPE,
151: p_quarter_num IN cn_period_statuses.quarter_num%TYPE,
152: p_period_year IN cn_period_statuses.period_year%TYPE,
153: p_pay_interval_type_id IN cn_pmt_plans.pay_interval_type_id%TYPE,
154: p_recoverable_interval_type_id IN cn_pmt_plans.recoverable_interval_type_id%TYPE,
155: x_pay_period_id OUT NOCOPY cn_pmt_plans.pay_interval_type_id%TYPE,
156: x_rec_period_id OUT NOCOPY cn_pmt_plans.recoverable_interval_type_id%TYPE,

Line 160: CURSOR get_max_period_id_in_qtr(p_quarter_num cn_period_statuses.quarter_num%TYPE, p_period_year cn_period_statuses.period_year%TYPE) IS

156: x_rec_period_id OUT NOCOPY cn_pmt_plans.recoverable_interval_type_id%TYPE,
157: --R12
158: p_org_id IN cn_payruns.org_id%TYPE
159: ) IS
160: CURSOR get_max_period_id_in_qtr(p_quarter_num cn_period_statuses.quarter_num%TYPE, p_period_year cn_period_statuses.period_year%TYPE) IS
161: SELECT MAX(p.period_id) max_period_id
162: FROM cn_period_statuses p,
163: cn_period_types pt
164: WHERE p.quarter_num = p_quarter_num

Line 162: FROM cn_period_statuses p,

158: p_org_id IN cn_payruns.org_id%TYPE
159: ) IS
160: CURSOR get_max_period_id_in_qtr(p_quarter_num cn_period_statuses.quarter_num%TYPE, p_period_year cn_period_statuses.period_year%TYPE) IS
161: SELECT MAX(p.period_id) max_period_id
162: FROM cn_period_statuses p,
163: cn_period_types pt
164: WHERE p.quarter_num = p_quarter_num
165: AND p.period_year = p_period_year
166: AND p.period_type = pt.period_type

Line 172: CURSOR get_max_period_id_in_yr(p_period_year cn_period_statuses.period_year%TYPE) IS

168: --R12
169: AND p.org_id = p_org_id
170: AND pt.org_id = p_org_id;
171:
172: CURSOR get_max_period_id_in_yr(p_period_year cn_period_statuses.period_year%TYPE) IS
173: SELECT MAX(p.period_id) max_period_id
174: FROM cn_period_statuses p,
175: cn_period_types pt
176: WHERE period_year = p_period_year

Line 174: FROM cn_period_statuses p,

170: AND pt.org_id = p_org_id;
171:
172: CURSOR get_max_period_id_in_yr(p_period_year cn_period_statuses.period_year%TYPE) IS
173: SELECT MAX(p.period_id) max_period_id
174: FROM cn_period_statuses p,
175: cn_period_types pt
176: WHERE period_year = p_period_year
177: AND p.period_type = pt.period_type
178: AND pt.period_type_id = 0

Line 315: p_period_set_id IN cn_period_statuses.period_set_id%TYPE,

311: -- ===========================================================================
312: PROCEDURE get_start_and_end_dates
313: (
314: p_interval_type_id IN NUMBER,
315: p_period_set_id IN cn_period_statuses.period_set_id%TYPE,
316: p_period_type_id IN cn_period_statuses.period_type_id%TYPE,
317: p_period_year IN cn_period_statuses.period_year%TYPE,
318: p_quarter_num IN cn_period_statuses.period_year%TYPE,
319: p_start_date IN cn_period_statuses.start_date%TYPE,

Line 316: p_period_type_id IN cn_period_statuses.period_type_id%TYPE,

312: PROCEDURE get_start_and_end_dates
313: (
314: p_interval_type_id IN NUMBER,
315: p_period_set_id IN cn_period_statuses.period_set_id%TYPE,
316: p_period_type_id IN cn_period_statuses.period_type_id%TYPE,
317: p_period_year IN cn_period_statuses.period_year%TYPE,
318: p_quarter_num IN cn_period_statuses.period_year%TYPE,
319: p_start_date IN cn_period_statuses.start_date%TYPE,
320: p_end_date IN cn_period_statuses.end_date%TYPE,

Line 317: p_period_year IN cn_period_statuses.period_year%TYPE,

313: (
314: p_interval_type_id IN NUMBER,
315: p_period_set_id IN cn_period_statuses.period_set_id%TYPE,
316: p_period_type_id IN cn_period_statuses.period_type_id%TYPE,
317: p_period_year IN cn_period_statuses.period_year%TYPE,
318: p_quarter_num IN cn_period_statuses.period_year%TYPE,
319: p_start_date IN cn_period_statuses.start_date%TYPE,
320: p_end_date IN cn_period_statuses.end_date%TYPE,
321: x_interval_start_date OUT NOCOPY cn_period_statuses.start_date%TYPE,

Line 318: p_quarter_num IN cn_period_statuses.period_year%TYPE,

314: p_interval_type_id IN NUMBER,
315: p_period_set_id IN cn_period_statuses.period_set_id%TYPE,
316: p_period_type_id IN cn_period_statuses.period_type_id%TYPE,
317: p_period_year IN cn_period_statuses.period_year%TYPE,
318: p_quarter_num IN cn_period_statuses.period_year%TYPE,
319: p_start_date IN cn_period_statuses.start_date%TYPE,
320: p_end_date IN cn_period_statuses.end_date%TYPE,
321: x_interval_start_date OUT NOCOPY cn_period_statuses.start_date%TYPE,
322: x_interval_end_date OUT NOCOPY cn_period_statuses.end_date%TYPE,

Line 319: p_start_date IN cn_period_statuses.start_date%TYPE,

315: p_period_set_id IN cn_period_statuses.period_set_id%TYPE,
316: p_period_type_id IN cn_period_statuses.period_type_id%TYPE,
317: p_period_year IN cn_period_statuses.period_year%TYPE,
318: p_quarter_num IN cn_period_statuses.period_year%TYPE,
319: p_start_date IN cn_period_statuses.start_date%TYPE,
320: p_end_date IN cn_period_statuses.end_date%TYPE,
321: x_interval_start_date OUT NOCOPY cn_period_statuses.start_date%TYPE,
322: x_interval_end_date OUT NOCOPY cn_period_statuses.end_date%TYPE,
323: --R12

Line 320: p_end_date IN cn_period_statuses.end_date%TYPE,

316: p_period_type_id IN cn_period_statuses.period_type_id%TYPE,
317: p_period_year IN cn_period_statuses.period_year%TYPE,
318: p_quarter_num IN cn_period_statuses.period_year%TYPE,
319: p_start_date IN cn_period_statuses.start_date%TYPE,
320: p_end_date IN cn_period_statuses.end_date%TYPE,
321: x_interval_start_date OUT NOCOPY cn_period_statuses.start_date%TYPE,
322: x_interval_end_date OUT NOCOPY cn_period_statuses.end_date%TYPE,
323: --R12
324: p_org_id IN cn_payruns.org_id%TYPE

Line 321: x_interval_start_date OUT NOCOPY cn_period_statuses.start_date%TYPE,

317: p_period_year IN cn_period_statuses.period_year%TYPE,
318: p_quarter_num IN cn_period_statuses.period_year%TYPE,
319: p_start_date IN cn_period_statuses.start_date%TYPE,
320: p_end_date IN cn_period_statuses.end_date%TYPE,
321: x_interval_start_date OUT NOCOPY cn_period_statuses.start_date%TYPE,
322: x_interval_end_date OUT NOCOPY cn_period_statuses.end_date%TYPE,
323: --R12
324: p_org_id IN cn_payruns.org_id%TYPE
325: ) IS

Line 322: x_interval_end_date OUT NOCOPY cn_period_statuses.end_date%TYPE,

318: p_quarter_num IN cn_period_statuses.period_year%TYPE,
319: p_start_date IN cn_period_statuses.start_date%TYPE,
320: p_end_date IN cn_period_statuses.end_date%TYPE,
321: x_interval_start_date OUT NOCOPY cn_period_statuses.start_date%TYPE,
322: x_interval_end_date OUT NOCOPY cn_period_statuses.end_date%TYPE,
323: --R12
324: p_org_id IN cn_payruns.org_id%TYPE
325: ) IS
326: l_interval_start_date cn_period_statuses.start_date%TYPE;

Line 326: l_interval_start_date cn_period_statuses.start_date%TYPE;

322: x_interval_end_date OUT NOCOPY cn_period_statuses.end_date%TYPE,
323: --R12
324: p_org_id IN cn_payruns.org_id%TYPE
325: ) IS
326: l_interval_start_date cn_period_statuses.start_date%TYPE;
327: l_interval_end_date cn_period_statuses.end_date%TYPE;
328: BEGIN
329: IF p_interval_type_id = -1000
330: THEN

Line 327: l_interval_end_date cn_period_statuses.end_date%TYPE;

323: --R12
324: p_org_id IN cn_payruns.org_id%TYPE
325: ) IS
326: l_interval_start_date cn_period_statuses.start_date%TYPE;
327: l_interval_end_date cn_period_statuses.end_date%TYPE;
328: BEGIN
329: IF p_interval_type_id = -1000
330: THEN
331: --period

Line 341: FROM cn_period_statuses

337: SELECT MIN(start_date),
338: MAX(end_date)
339: INTO l_interval_start_date,
340: l_interval_end_date
341: FROM cn_period_statuses
342: WHERE period_set_id = p_period_set_id
343: AND period_type_id = p_period_type_id
344: AND quarter_num = p_quarter_num
345: AND period_year = p_period_year

Line 354: FROM cn_period_statuses

350: SELECT MIN(start_date),
351: MAX(end_date)
352: INTO l_interval_start_date,
353: l_interval_end_date
354: FROM cn_period_statuses
355: WHERE period_set_id = p_period_set_id
356: AND period_type_id = p_period_type_id
357: AND period_year = p_period_year
358: --R12

Line 405: cn_period_statuses ps

401: decode(nvl(p_incentive_type, cnq.incentive_type_code), 'COMMISSION', 'COMMISSION', 'BONUS', 'BONUS', cnq.incentive_type_code)
402: -- BUG 3140343 Payee design
403: AND cspq.quota_id NOT IN (SELECT spayee.quota_id
404: FROM cn_srp_payee_assigns spayee,
405: cn_period_statuses ps
406: WHERE (spayee.salesrep_id = p_salesrep_id OR spayee.payee_id = p_salesrep_id)
407: AND ps.period_id = p_period_id
408: AND ps.end_date >= spayee.start_date
409: --R12

Line 431: cn_period_statuses ps

427: decode(nvl(p_incentive_type, cnq.incentive_type_code), 'COMMISSION', 'COMMISSION', 'BONUS', 'BONUS', cnq.incentive_type_code)
428: -- BUG 3140343 Payee design
429: AND cspq.quota_id NOT IN (SELECT spayee.quota_id
430: FROM cn_srp_payee_assigns spayee,
431: cn_period_statuses ps
432: WHERE (spayee.salesrep_id = p_salesrep_id OR spayee.payee_id = p_salesrep_id)
433: AND ps.period_id = p_period_id
434: AND ps.end_date >= spayee.start_date
435: --R12

Line 530: cn_period_statuses_all ps

526: AND NOT EXISTS (
527: -- separate queries for performance reasons. merge cartesian reported
528: SELECT 1
529: FROM cn_srp_payee_assigns_all spayee,
530: cn_period_statuses_all ps
531: WHERE (spayee.salesrep_id = p_salesrep_id)
532: AND ps.period_id = cnp.pay_period_id
533: AND ps.end_date >= spayee.start_date
534: AND ps.org_id = p_org_id

Line 540: cn_period_statuses_all ps

536: AND ps.start_date <= nvl(spayee.end_date, ps.end_date)
537: UNION ALL
538: SELECT 1
539: FROM cn_srp_payee_assigns_all spayee,
540: cn_period_statuses_all ps
541: WHERE spayee.payee_id = p_salesrep_id
542: AND ps.period_id = cnp.pay_period_id
543: AND ps.end_date >= spayee.start_date
544: AND ps.org_id = p_org_id

Line 580: cn_period_statuses_all ps

576: AND NOT EXISTS (
577: -- separate queries for performance reasons. merge cartesian reported
578: SELECT 1
579: FROM cn_srp_payee_assigns_all spayee,
580: cn_period_statuses_all ps
581: WHERE (spayee.salesrep_id = p_salesrep_id)
582: AND ps.period_id = cnp.pay_period_id
583: AND ps.end_date >= spayee.start_date
584: AND ps.org_id = p_org_id

Line 590: cn_period_statuses_all ps

586: AND ps.start_date <= nvl(spayee.end_date, ps.end_date)
587: UNION ALL
588: SELECT 1
589: FROM cn_srp_payee_assigns_all spayee,
590: cn_period_statuses_all ps
591: WHERE spayee.payee_id = p_salesrep_id
592: AND ps.period_id = cnp.pay_period_id
593: AND ps.end_date >= spayee.start_date
594: AND ps.org_id = p_org_id

Line 928: FROM cn_period_statuses

924: period_set_id,
925: period_type_id,
926: start_date,
927: end_date
928: FROM cn_period_statuses
929: WHERE period_id = p_period_id
930: --R12
931: AND org_id = p_org_id;
932:

Line 937: FROM cn_period_statuses

933: l_get_prd_statuses get_prd_statuses%ROWTYPE;
934:
935: CURSOR get_qtr_sdate(p_period_set_id NUMBER, p_period_type_id NUMBER, p_period_year NUMBER, p_quarter_num NUMBER) IS
936: SELECT MIN(start_date)
937: FROM cn_period_statuses
938: WHERE period_set_id = p_period_set_id
939: AND period_type_id = p_period_type_id
940: AND period_year = p_period_year
941: AND quarter_num = p_quarter_num

Line 947: FROM cn_period_statuses

943: AND org_id = p_org_id;
944:
945: CURSOR get_qtr_edate(p_period_set_id NUMBER, p_period_type_id NUMBER, p_period_year NUMBER, p_quarter_num NUMBER) IS
946: SELECT MAX(end_date)
947: FROM cn_period_statuses
948: WHERE period_set_id = p_period_set_id
949: AND period_type_id = p_period_type_id
950: AND period_year = p_period_year
951: AND quarter_num = p_quarter_num

Line 957: FROM cn_period_statuses

953: AND org_id = p_org_id;
954:
955: CURSOR get_year_sdate(p_period_set_id NUMBER, p_period_type_id NUMBER, p_period_year NUMBER) IS
956: SELECT MIN(start_date)
957: FROM cn_period_statuses
958: WHERE period_set_id = p_period_set_id
959: AND period_type_id = p_period_type_id
960: AND period_year = p_period_year
961: AND org_id = p_org_id;

Line 965: FROM cn_period_statuses

961: AND org_id = p_org_id;
962:
963: CURSOR get_year_edate(p_period_set_id NUMBER, p_period_type_id NUMBER, p_period_year NUMBER) IS
964: SELECT MAX(end_date)
965: FROM cn_period_statuses
966: WHERE period_set_id = p_period_set_id
967: AND period_type_id = p_period_type_id
968: AND period_year = p_period_year
969: AND org_id = p_org_id;

Line 977: cn_period_statuses ps

973: CURSOR get_itd_amount_paid(p_period_set_id NUMBER, p_period_type_id NUMBER, p_interval_sdate DATE, p_interval_edate DATE, p_pg_code cn_pmt_plans.payment_group_code%TYPE) IS
974: SELECT nvl(SUM(balance1_dtd - balance1_ctd), 0) payment
975: FROM cn_srp_periods csp,
976: cn_quotas_all q,
977: cn_period_statuses ps
978: WHERE csp.period_id = ps.period_id
979: AND ps.period_set_id = p_period_set_id
980: AND ps.period_type_id = p_period_type_id
981: AND ps.start_date >= p_interval_sdate

Line 1018: l_pay_period_id cn_period_statuses.period_id%TYPE;

1014: l_earnings NUMBER := 0;
1015: l_recovery NUMBER := 0;
1016: l_ctr_amount NUMBER := 0;
1017: --variables added for bug 2776847 by jjhuang
1018: l_pay_period_id cn_period_statuses.period_id%TYPE;
1019: l_rec_period_id cn_period_statuses.period_id%TYPE;
1020: l_pmt_plan_count NUMBER := 0;
1021: -- varialve added for Bug 3140343
1022: l_ispayee NUMBER := 0;

Line 1019: l_rec_period_id cn_period_statuses.period_id%TYPE;

1015: l_recovery NUMBER := 0;
1016: l_ctr_amount NUMBER := 0;
1017: --variables added for bug 2776847 by jjhuang
1018: l_pay_period_id cn_period_statuses.period_id%TYPE;
1019: l_rec_period_id cn_period_statuses.period_id%TYPE;
1020: l_pmt_plan_count NUMBER := 0;
1021: -- varialve added for Bug 3140343
1022: l_ispayee NUMBER := 0;
1023: --Bug 3198445 by jjhuang

Line 1044: ' FROM cn_srp_pmt_plans cspp,cn_pmt_plans cnpp,cn_period_statuses cnps ' || ' WHERE ' || ' cspp.salesrep_id = :p_salesrep_id' ||

1040: ' cnpp.recoverable_interval_type_id,' || ' nvl(cnpp.pay_against_commission, ''Y'') pay_against_commission,' || ' cnpp.payment_group_code,' ||
1041: ' cspp.minimum_amount,' || ' cnpp.min_rec_flag,' || ' cnpp.max_rec_flag,' || ' cspp.maximum_amount,' || ' cnps.period_id,' ||
1042: ' cspp.salesrep_id,' || ' cnps.start_date prd_start_date,' || ' cnps.end_date prd_end_date,' || ' cnpp.name,' ||
1043: ' ROW_NUMBER() over (PARTITION BY cnpp.payment_group_code' || ' ORDER BY cspp.start_date DESC) AS row_nums ,' || ' cnpp.credit_type_id' ||
1044: ' FROM cn_srp_pmt_plans cspp,cn_pmt_plans cnpp,cn_period_statuses cnps ' || ' WHERE ' || ' cspp.salesrep_id = :p_salesrep_id' ||
1045: ' AND cnpp.pmt_plan_id = cspp.pmt_plan_id ' || ' AND cnps.period_id = :p_period_id' || ' AND cnpp.credit_type_id = -1000' ||
1046: ' AND cspp.start_date <= cnps.end_date' ||
1047: -- ' AND Nvl(cspp.end_date,cnps.start_date) >= cnps.start_date' ||
1048: --bug 3395792 by jjhuang on 1/23/04

Line 1419: FROM cn_period_statuses

1415: period_set_id,
1416: period_type_id,
1417: start_date,
1418: end_date
1419: FROM cn_period_statuses
1420: WHERE period_id = p_period_id
1421: AND org_id = p_worksheet_rec.org_id;
1422:
1423: CURSOR get_srp_total(p_period_id NUMBER) IS

Line 2215: cn_period_statuses cnps

2211: cns.NAME salesrep_name
2212: FROM cn_payruns cnp,
2213: cn_srp_pay_groups cnspg,
2214: cn_salesreps cns,
2215: cn_period_statuses cnps
2216: WHERE cnp.payrun_id = c_payrun_id
2217: AND cnp.status = 'UNPAID'
2218: AND cnp.pay_group_id = cnspg.pay_group_id
2219: AND cnspg.salesrep_id = cns.salesrep_id

Line 2300: cn_period_statuses cnps

2296: cns.NAME salesrep_name
2297: FROM cn_payruns cnp,
2298: cn_srp_pay_groups cnspg,
2299: cn_salesreps cns,
2300: cn_period_statuses cnps
2301: WHERE cnp.payrun_id = l_payrun_id
2302: AND cnp.status = 'UNPAID'
2303: AND cnp.pay_group_id = cnspg.pay_group_id
2304: AND cnspg.salesrep_id = cns.salesrep_id