APPS.CN_SRP_PERIOD_QUOTAS_PKG dependencies on CN_CAL_PER_INT_TYPES_ALL

Line 93: FROM cn_cal_per_int_types_all

89: cursor max_prev_period_csr(p_interval_type_id NUMBER,
90: p_start_period_id NUMBER,
91: p_org_id NUMBER) is
92: SELECT max(cal_period_id) max_cal_period_id
93: FROM cn_cal_per_int_types_all
94: WHERE interval_type_id = p_interval_type_id
95: AND org_id = p_org_id
96: AND cal_period_id < p_start_period_id
97: AND interval_number =

Line 98: (select interval_number from cn_cal_per_int_types_all

94: WHERE interval_type_id = p_interval_type_id
95: AND org_id = p_org_id
96: AND cal_period_id < p_start_period_id
97: AND interval_number =
98: (select interval_number 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 107: FROM cn_cal_per_int_types_all

103: cursor max_period_csr(p_interval_type_id NUMBER,
104: p_start_period_id NUMBER,
105: p_org_id NUMBER) is
106: SELECT cal_period_id
107: FROM cn_cal_per_int_types_all
108: WHERE interval_type_id = p_interval_type_id
109: AND org_id = p_org_id
110: AND cal_period_id >= p_start_period_id
111: AND interval_number =

Line 112: (select interval_number from cn_cal_per_int_types_all

108: WHERE interval_type_id = p_interval_type_id
109: AND org_id = p_org_id
110: AND cal_period_id >= p_start_period_id
111: AND interval_number =
112: (select interval_number from cn_cal_per_int_types_all
113: where cal_period_id = p_start_period_id
114: AND org_id = p_org_id
115: and interval_type_id = p_interval_type_id);
116:

Line 230: cn_cal_per_int_types_all cpit,

226: nvl(spq.performance_goal_ptd,0) performance_goal_ptd
227: FROM
228: cn_srp_period_quotas_all spq,
229: cn_period_statuses_all cp,
230: cn_cal_per_int_types_all cpit,
231: cn_quotas_all cq
232: WHERE spq.quota_id = x_quota_id
233: AND spq.quota_id = cq.quota_id
234: AND spq.period_id = cp.period_id

Line 257: cn_cal_per_int_types_all cpit,

253: cpit.interval_number interval_number,
254: p.period_year period_year
255: FROM cn_srp_period_quotas_v p,
256: cn_period_statuses cp,
257: cn_cal_per_int_types_all cpit,
258: cn_quotas_all cq
259: WHERE p.quota_id = x_quota_id
260: AND p.quota_id = cq.quota_id
261: AND p.period_id = cp.period_id

Line 900: cn_cal_per_int_types_all cpit,

896: ,spq.period_payment
897: ,spq.performance_goal_ptd
898: FROM cn_srp_period_quotas_v spq,
899: cn_period_statuses cp,
900: cn_cal_per_int_types_all cpit,
901: cn_quotas_all cq
902: WHERE spq.srp_quota_assign_id = x_srp_quota_assign_id
903: AND spq.quota_id = cq.quota_id
904: AND spq.period_id = cp.period_id

Line 927: cn_cal_per_int_types_all cpit,

923: cpit.interval_number interval_number,
924: spq.period_year period_year
925: FROM cn_srp_period_quotas_v spq,
926: cn_period_statuses cp,
927: cn_cal_per_int_types_all cpit,
928: cn_quotas_all cq
929: WHERE spq.srp_quota_assign_id = x_srp_quota_assign_id
930: AND spq.quota_id = cq.quota_id
931: AND spq.period_id = cp.period_id

Line 1533: cn_cal_per_int_types_all cpit,

1529: CURSOR period_quotas(l_interval_number NUMBER, l_period_year NUMBER) IS
1530: SELECT spq.srp_period_quota_id
1531: FROM cn_srp_period_quotas_v spq,
1532: cn_period_statuses cp,
1533: cn_cal_per_int_types_all cpit,
1534: cn_quotas_all cq
1535: WHERE spq.srp_quota_assign_id = x_srp_quota_assign_id
1536: AND spq.quota_id = cq.quota_id
1537: AND spq.period_id = cp.period_id

Line 1560: cn_cal_per_int_types_all cpit,

1556: cpit.interval_number interval_number,
1557: spq.period_year period_year
1558: FROM cn_srp_period_quotas_v spq,
1559: cn_period_statuses cp,
1560: cn_cal_per_int_types_all cpit,
1561: cn_quotas_all cq
1562: WHERE spq.srp_quota_assign_id = x_srp_quota_assign_id
1563: AND spq.quota_id = cq.quota_id
1564: AND spq.period_id = cp.period_id