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 148: p_period_id IN cn_period_statuses.period_id%TYPE,

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

Line 149: p_quarter_num IN cn_period_statuses.quarter_num%TYPE,

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

Line 150: p_period_year IN cn_period_statuses.period_year%TYPE,

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

Line 158: 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

154: x_rec_period_id OUT NOCOPY cn_pmt_plans.recoverable_interval_type_id%TYPE,
155: --R12
156: p_org_id IN cn_payruns.org_id%TYPE
157: ) IS
158: 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
159: SELECT MAX(p.period_id) max_period_id
160: FROM cn_period_statuses p,
161: cn_period_types pt
162: WHERE p.quarter_num = p_quarter_num

Line 160: FROM cn_period_statuses p,

156: p_org_id IN cn_payruns.org_id%TYPE
157: ) IS
158: 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
159: SELECT MAX(p.period_id) max_period_id
160: FROM cn_period_statuses p,
161: cn_period_types pt
162: WHERE p.quarter_num = p_quarter_num
163: AND p.period_year = p_period_year
164: AND p.period_type = pt.period_type

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

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

Line 172: FROM cn_period_statuses p,

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

Line 313: p_period_set_id IN cn_period_statuses.period_set_id%TYPE,

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

Line 314: p_period_type_id IN cn_period_statuses.period_type_id%TYPE,

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

Line 315: p_period_year IN cn_period_statuses.period_year%TYPE,

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

Line 316: p_quarter_num IN cn_period_statuses.period_year%TYPE,

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

Line 317: p_start_date IN cn_period_statuses.start_date%TYPE,

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

Line 318: p_end_date IN cn_period_statuses.end_date%TYPE,

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

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

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

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

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

Line 324: l_interval_start_date cn_period_statuses.start_date%TYPE;

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

Line 325: l_interval_end_date cn_period_statuses.end_date%TYPE;

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

Line 339: FROM cn_period_statuses

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

Line 352: FROM cn_period_statuses

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

Line 403: cn_period_statuses ps

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

Line 429: cn_period_statuses ps

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

Line 528: cn_period_statuses_all ps

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

Line 538: cn_period_statuses_all ps

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

Line 578: cn_period_statuses_all ps

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

Line 588: cn_period_statuses_all ps

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

Line 926: FROM cn_period_statuses

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

Line 935: FROM cn_period_statuses

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

Line 945: FROM cn_period_statuses

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

Line 955: FROM cn_period_statuses

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

Line 963: FROM cn_period_statuses

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

Line 975: cn_period_statuses ps

971: 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
972: SELECT nvl(SUM(balance1_dtd - balance1_ctd), 0) payment
973: FROM cn_srp_periods csp,
974: cn_quotas_all q,
975: cn_period_statuses ps
976: WHERE csp.period_id = ps.period_id
977: AND ps.period_set_id = p_period_set_id
978: AND ps.period_type_id = p_period_type_id
979: AND ps.start_date >= p_interval_sdate

Line 1016: l_pay_period_id cn_period_statuses.period_id%TYPE;

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

Line 1017: l_rec_period_id cn_period_statuses.period_id%TYPE;

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

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

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

Line 1417: FROM cn_period_statuses

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

Line 2258: cn_period_statuses cnps

2254: cns.NAME salesrep_name
2255: FROM cn_payruns cnp,
2256: cn_srp_pay_groups cnspg,
2257: cn_salesreps cns,
2258: cn_period_statuses cnps
2259: WHERE cnp.payrun_id = l_payrun_id
2260: AND cnp.status = 'UNPAID'
2261: AND cnp.pay_group_id = cnspg.pay_group_id
2262: AND cnspg.salesrep_id = cns.salesrep_id