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_CAL_PER_INT_TYPES_ALL

Line 78: FROM cn_cal_per_int_types_all

74: l_performance_goal_itd NUMBER := 0;
75: CURSOR max_prev_period_csr(p_interval_type_id NUMBER, p_start_period_id NUMBER, p_org_id NUMBER)
76: IS
77: SELECT MAX(cal_period_id) max_cal_period_id
78: FROM cn_cal_per_int_types_all
79: WHERE interval_type_id = p_interval_type_id
80: AND org_id = p_org_id
81: AND cal_period_id < p_start_period_id
82: AND interval_number =

Line 84: FROM cn_cal_per_int_types_all

80: AND org_id = p_org_id
81: AND cal_period_id < p_start_period_id
82: AND interval_number =
83: (SELECT interval_number
84: FROM cn_cal_per_int_types_all
85: WHERE cal_period_id = p_start_period_id
86: AND org_id = p_org_id
87: AND interval_type_id = p_interval_type_id
88: );

Line 92: FROM cn_cal_per_int_types_all

88: );
89: CURSOR max_period_csr(p_interval_type_id NUMBER, p_start_period_id NUMBER, p_org_id NUMBER)
90: IS
91: SELECT cal_period_id
92: FROM cn_cal_per_int_types_all
93: WHERE interval_type_id = p_interval_type_id
94: AND org_id = p_org_id
95: AND cal_period_id >= p_start_period_id
96: AND interval_number =

Line 98: FROM cn_cal_per_int_types_all

94: AND org_id = p_org_id
95: AND cal_period_id >= p_start_period_id
96: AND interval_number =
97: (SELECT interval_number
98: FROM cn_cal_per_int_types_all
99: WHERE cal_period_id = p_start_period_id
100: AND org_id = p_org_id
101: AND interval_type_id = p_interval_type_id
102: );

Line 245: cn_cal_per_int_types_all cpit ,

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
249: AND spq.period_id = cp.period_id

Line 270: cn_cal_per_int_types_all cpit ,

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
274: AND p.period_id = cp.period_id

Line 898: cn_cal_per_int_types_all cpit ,

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
902: AND spq.period_id = cp.period_id

Line 922: cn_cal_per_int_types_all cpit ,

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
926: AND spq.period_id = cp.period_id

Line 1495: cn_cal_per_int_types_all cpit ,

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
1499: AND spq.period_id = cp.period_id

Line 1519: cn_cal_per_int_types_all cpit ,

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
1523: AND spq.period_id = cp.period_id