APPS.CN_SRP_PERIOD_QUOTAS_PKG dependencies on CN_SRP_PERIOD_QUOTAS_V

Line 255: FROM cn_srp_period_quotas_v p,

251: p.srp_quota_assign_id srp_quota_assign_id,
252: count(p.srp_period_quota_id) interval_count,
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

Line 876: FROM cn_srp_period_quotas_v

872: CURSOR quart_counts IS
873: SELECT count(srp_period_quota_id) quart_yr_count
874: ,quarter_num
875: ,period_year
876: FROM cn_srp_period_quotas_v
877: WHERE srp_quota_assign_id = x_srp_quota_assign_id
878: GROUP BY quarter_num,period_year
879: ;
880: quart_rec quart_counts%ROWTYPE;

Line 887: FROM cn_srp_period_quotas_v

883: -- covers.
884: CURSOR year_counts IS
885: SELECT count(srp_period_quota_id) year_count
886: ,period_year
887: FROM cn_srp_period_quotas_v
888: WHERE srp_quota_assign_id = x_srp_quota_assign_id
889: GROUP BY period_year
890: ;
891: year_rec year_counts%ROWTYPE;

Line 898: FROM cn_srp_period_quotas_v spq,

894: SELECT spq.srp_period_quota_id
895: ,spq.target_amount
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

Line 925: FROM cn_srp_period_quotas_v spq,

921: CURSOR interval_counts IS
922: SELECT count(spq.srp_period_quota_id) interval_count,
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

Line 1531: FROM cn_srp_period_quotas_v spq,

1527: ,x_period_target_unit_code VARCHAR2) IS
1528:
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

Line 1558: FROM cn_srp_period_quotas_v spq,

1554: CURSOR interval_counts IS
1555: SELECT count(spq.srp_period_quota_id) interval_count,
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