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_ALL

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 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 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 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