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_MARK_EVENTS_PKG dependencies on CN_CAL_PER_INT_TYPES_ALL

Line 579: FROM cn_cal_per_int_types_all cpit1, cn_cal_per_int_types_all cpit2

575: ) IS --required
576: CURSOR l_all_srp_periods_csr IS
577: -- 1). for salesrep_id = -1000 /period_id
578: SELECT DISTINCT cpit2.cal_period_id
579: FROM cn_cal_per_int_types_all cpit1, cn_cal_per_int_types_all cpit2
580: WHERE cpit1.cal_period_id = p_period_id
581: AND cpit1.org_id = p_org_id
582: AND cpit2.interval_type_id = cpit1.interval_type_id
583: AND cpit2.interval_number = cpit1.interval_number

Line 590: FROM cn_cal_per_int_types_all cpit2

586:
587: CURSOR l_single_srp_periods_csr IS
588: -- 2). for salesrep_id/ period_id
589: SELECT DISTINCT cpit2.cal_period_id
590: FROM cn_cal_per_int_types_all cpit2
591: WHERE (cpit2.interval_type_id, cpit2.interval_number) IN(
592: SELECT interval_type_id
593: , interval_number
594: FROM cn_cal_per_int_types_all

Line 594: FROM cn_cal_per_int_types_all

590: FROM cn_cal_per_int_types_all cpit2
591: WHERE (cpit2.interval_type_id, cpit2.interval_number) IN(
592: SELECT interval_type_id
593: , interval_number
594: FROM cn_cal_per_int_types_all
595: WHERE cal_period_id = p_period_id
596: AND interval_type_id IN(
597: SELECT DISTINCT q.interval_type_id
598: FROM cn_quotas_all q

Line 634: FROM cn_cal_per_int_types_all cpit2

630:
631: CURSOR l_single_srp_pe_periods_csr IS
632: -- 3). for salesrep_id/ period_id /quota_id
633: SELECT cpit2.cal_period_id
634: FROM cn_cal_per_int_types_all cpit2
635: WHERE (cpit2.interval_type_id, cpit2.interval_number, cpit2.org_id) =
636: (SELECT cpit1.interval_type_id
637: , cpit1.interval_number
638: , cpit1.org_id

Line 639: FROM cn_cal_per_int_types_all cpit1

635: WHERE (cpit2.interval_type_id, cpit2.interval_number, cpit2.org_id) =
636: (SELECT cpit1.interval_type_id
637: , cpit1.interval_number
638: , cpit1.org_id
639: FROM cn_cal_per_int_types_all cpit1
640: WHERE cpit1.cal_period_id = p_period_id
641: AND cpit1.org_id = p_org_id
642: AND cpit1.interval_type_id =
643: (SELECT interval_type_id

Line 3602: FROM cn_cal_per_int_types_all cpit, cn_period_statuses_all ps

3598: CURSOR affected_periods IS
3599: SELECT cpit.cal_period_id
3600: , ps.start_date
3601: , ps.end_date
3602: FROM cn_cal_per_int_types_all cpit, cn_period_statuses_all ps
3603: WHERE (
3604: cpit.interval_number = p_old_interval_number
3605: OR cpit.interval_number = p_new_interval_number
3606: )

Line 3675: FROM cn_cal_per_int_types_all

3671: SELECT cal_period_id
3672: , interval_number
3673: , interval_type_id
3674: , org_id
3675: FROM cn_cal_per_int_types_all
3676: WHERE cal_per_int_type_id = x_cal_per_int_type_id
3677: FOR UPDATE OF cal_per_int_type_id NOWAIT;
3678:
3679: rec c%ROWTYPE;