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

Line 244: cn_period_statuses_all cp ,

240: NVL(spq.target_amount,0) target_amount ,
241: NVL(spq.period_payment,0) period_payment ,
242: NVL(spq.performance_goal_ptd,0) performance_goal_ptd
243: FROM cn_srp_period_quotas_all spq,
244: cn_period_statuses_all cp ,
245: cn_cal_per_int_types_all cpit ,
246: cn_quotas_all cq
247: WHERE spq.quota_id = x_quota_id
248: AND spq.quota_id = cq.quota_id

Line 269: cn_period_statuses cp ,

265: COUNT(p.srp_period_quota_id) interval_count ,
266: cpit.interval_number interval_number ,
267: p.period_year period_year
268: FROM cn_srp_period_quotas_v p,
269: cn_period_statuses cp ,
270: cn_cal_per_int_types_all cpit ,
271: cn_quotas_all cq
272: WHERE p.quota_id = x_quota_id
273: AND p.quota_id = cq.quota_id

Line 516: cn_period_statuses p

512: qa.org_id
513: FROM cn_srp_quota_assigns_all qa ,
514: cn_period_quotas_all pq ,
515: cn_srp_plan_assigns_all pa ,
516: cn_period_statuses p
517: WHERE qa.srp_plan_assign_id = x_srp_plan_assign_id
518: AND pa.srp_plan_assign_id = x_srp_plan_assign_id
519: AND pa.srp_plan_assign_id = qa.srp_plan_assign_id --bugfix3633222
520: AND qa.quota_id = pq.quota_id

Line 537: FROM CN_PERIOD_STATUSES_ALL R1

533: -- bug 2460926, clku, check if all the open period ends before the specified start_date
534: -- 2479359, Nvl(x_start_date, pa.start_date) added to deal with NULL x_start_date
535: AND EXISTS
536: (SELECT r1.end_date
537: FROM CN_PERIOD_STATUSES_ALL R1
538: WHERE r1.end_date >= NVL(x_start_date, pa.start_date)
539: AND (R1.PERIOD_SET_ID, R1.PERIOD_TYPE_ID ) IN
540: (SELECT CR.PERIOD_SET_ID,
541: CR.PERIOD_TYPE_ID

Line 631: cn_period_statuses p

627: qa.org_id
628: FROM cn_srp_quota_assigns_all qa ,
629: cn_period_quotas_all pq ,
630: cn_srp_plan_assigns_all pa ,
631: cn_period_statuses p
632: WHERE qa.srp_plan_assign_id = x_srp_plan_assign_id
633: AND pa.srp_plan_assign_id = qa.srp_plan_assign_id
634: AND qa.quota_id = x_quota_id
635: AND greatest(pa.start_date, p.start_date) <= least(NVL(pa.end_date,p.end_date), p.end_date)

Line 649: FROM CN_PERIOD_STATUSES_ALL R1

645: AND spq.period_id = p.period_id
646: )
647: AND EXISTS
648: (SELECT r1.end_date
649: FROM CN_PERIOD_STATUSES_ALL R1
650: WHERE r1.end_date >= NVL(x_start_date, pa.start_date)
651: AND (R1.PERIOD_SET_ID, R1.PERIOD_TYPE_ID ) IN
652: (SELECT CR.PERIOD_SET_ID,
653: CR.PERIOD_TYPE_ID

Line 734: cn_period_statuses p2 ,

730: cn_srp_plan_assigns_all pa ,
731: cn_acc_period_statuses_v p
732: -- bug fix 4042235
733: ,
734: cn_period_statuses p2 ,
735: cn_period_statuses p3
736: WHERE qa.srp_plan_assign_id = pa.srp_plan_assign_id
737: AND qa.quota_id = x_quota_id
738: AND q.quota_id = x_quota_id

Line 735: cn_period_statuses p3

731: cn_acc_period_statuses_v p
732: -- bug fix 4042235
733: ,
734: cn_period_statuses p2 ,
735: cn_period_statuses p3
736: WHERE qa.srp_plan_assign_id = pa.srp_plan_assign_id
737: AND qa.quota_id = x_quota_id
738: AND q.quota_id = x_quota_id
739: AND q.quota_id = qa.quota_id --bugfix#3633222

Line 766: FROM CN_PERIOD_STATUSES_ALL R1

762: )
763: -- bug 2460926, check if all the open period ends before the specified start_date
764: AND EXISTS
765: (SELECT r1.end_date
766: FROM CN_PERIOD_STATUSES_ALL R1
767: WHERE r1.end_date >= NVL(x_start_date, pa.start_date)
768: AND (R1.PERIOD_SET_ID, R1.PERIOD_TYPE_ID ) IN
769: (SELECT CR.PERIOD_SET_ID,
770: CR.PERIOD_TYPE_ID

Line 897: cn_period_statuses cp ,

893: spq.target_amount ,
894: spq.period_payment ,
895: spq.performance_goal_ptd
896: FROM cn_srp_period_quotas_v spq,
897: cn_period_statuses cp ,
898: cn_cal_per_int_types_all cpit ,
899: cn_quotas_all cq
900: WHERE spq.srp_quota_assign_id = x_srp_quota_assign_id
901: AND spq.quota_id = cq.quota_id

Line 921: cn_period_statuses cp ,

917: SELECT COUNT(spq.srp_period_quota_id) interval_count,
918: cpit.interval_number interval_number ,
919: spq.period_year period_year
920: FROM cn_srp_period_quotas_v spq,
921: cn_period_statuses cp ,
922: cn_cal_per_int_types_all cpit ,
923: cn_quotas_all cq
924: WHERE spq.srp_quota_assign_id = x_srp_quota_assign_id
925: AND spq.quota_id = cq.quota_id

Line 947: cn_period_statuses acc

943: acc.end_date ,
944: srp.org_id
945: FROM cn_srp_period_quotas_all period,
946: cn_salesreps srp ,
947: cn_period_statuses acc
948: WHERE period.srp_period_quota_id = x_srp_period_quota_id
949: AND acc.period_id = period.period_id
950: AND acc.org_id = period.org_id
951: AND acc.period_status IN ('O', 'F')

Line 1037: FROM cn_period_statuses aps

1033: WHERE spq.salesrep_id = x_salesrep_id
1034: AND spq.quota_id = x_quota_id
1035: AND EXISTS
1036: (SELECT 1
1037: FROM cn_period_statuses aps
1038: WHERE x_end_date BETWEEN aps.start_date AND aps.end_date
1039: AND aps.period_id = spq.period_id
1040: AND aps.period_status IN ('O', 'F')
1041: AND aps.org_id = spq.org_id

Line 1111: FROM cn_period_statuses p

1107: WHERE quota_id = l_quota_id
1108: AND srp_plan_assign_id = NVL(x_srp_plan_assign_id, srp_plan_assign_id)
1109: AND EXISTS
1110: (SELECT 1
1111: FROM cn_period_statuses p
1112: WHERE TRUNC(p.start_date) >= TRUNC(NVL(x_start_date,p.start_date))
1113: AND TRUNC(p.end_date) <= TRUNC(NVL(x_end_date ,p.end_date))
1114: AND cn_srp_period_quotas_all.period_id = p.period_id
1115: AND p.period_status IN ('O', 'F')

Line 1134: FROM cn_period_statuses p

1130: WHERE quota_id = x_quota_id
1131: AND org_id = l_org_id
1132: AND EXISTS
1133: (SELECT 1
1134: FROM cn_period_statuses p
1135: WHERE TRUNC(p.start_date) >= TRUNC(NVL(x_start_date,p.start_date))
1136: AND TRUNC(p.end_date) <= TRUNC(NVL(x_end_date ,p.end_date))
1137: AND cn_srp_periods_all.period_id = p.period_id
1138: AND p.period_status IN ('O', 'F')

Line 1223: FROM cn_period_statuses p

1219: FROM cn_srp_period_quotas_all
1220: WHERE srp_plan_assign_id = x_srp_plan_assign_id
1221: AND EXISTS
1222: (SELECT 1
1223: FROM cn_period_statuses p
1224: WHERE TRUNC(p.start_date) >= TRUNC(NVL(x_start_date,p.start_date))
1225: -- following line changed for bug 4424669, 4885986
1226: AND TRUNC(p.end_date) <= NVL(l_end_date_pd, p.end_date)
1227: --AND trunc(p.end_date) <= trunc(cn_end_date_period(nvl(x_end_date ,p.end_date), p.org_id))

Line 1277: FROM cn_period_statuses p

1273: FROM cn_srp_period_quotas_all
1274: WHERE quota_id = x_quota_id
1275: AND EXISTS
1276: (SELECT 1
1277: FROM cn_period_statuses p
1278: WHERE TRUNC(p.start_date) >= TRUNC(NVL(x_start_date,p.start_date))
1279: AND TRUNC(p.end_date) <= TRUNC(NVL(x_end_date ,p.end_date))
1280: AND cn_srp_period_quotas_all.period_id = p.period_id
1281: AND p.period_status IN ('O', 'F')

Line 1494: cn_period_statuses cp ,

1490: CURSOR period_quotas(l_interval_number NUMBER, l_period_year NUMBER)
1491: IS
1492: SELECT spq.srp_period_quota_id
1493: FROM cn_srp_period_quotas_v spq,
1494: cn_period_statuses cp ,
1495: cn_cal_per_int_types_all cpit ,
1496: cn_quotas_all cq
1497: WHERE spq.srp_quota_assign_id = x_srp_quota_assign_id
1498: AND spq.quota_id = cq.quota_id

Line 1518: cn_period_statuses cp ,

1514: SELECT COUNT(spq.srp_period_quota_id) interval_count,
1515: cpit.interval_number interval_number ,
1516: spq.period_year period_year
1517: FROM cn_srp_period_quotas_v spq,
1518: cn_period_statuses cp ,
1519: cn_cal_per_int_types_all cpit ,
1520: cn_quotas_all cq
1521: WHERE spq.srp_quota_assign_id = x_srp_quota_assign_id
1522: AND spq.quota_id = cq.quota_id