APPS.CN_SRP_PERIOD_QUOTAS_PKG dependencies on CN_SRP_PERIOD_QUOTAS_V

Line 268: FROM cn_srp_period_quotas_v p,

264: SELECT p.srp_quota_assign_id srp_quota_assign_id,
265: COUNT(p.srp_period_quota_id) interval_count ,
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

Line 873: FROM cn_srp_period_quotas_v

869: IS
870: SELECT COUNT(srp_period_quota_id) quart_yr_count ,
871: quarter_num ,
872: period_year
873: FROM cn_srp_period_quotas_v
874: WHERE srp_quota_assign_id = x_srp_quota_assign_id
875: GROUP BY quarter_num,
876: period_year ;
877:

Line 885: FROM cn_srp_period_quotas_v

881: CURSOR year_counts
882: IS
883: SELECT COUNT(srp_period_quota_id) year_count ,
884: period_year
885: FROM cn_srp_period_quotas_v
886: WHERE srp_quota_assign_id = x_srp_quota_assign_id
887: GROUP BY period_year ;
888:
889: year_rec year_counts%ROWTYPE;

Line 896: FROM cn_srp_period_quotas_v spq,

892: SELECT spq.srp_period_quota_id ,
893: spq.target_amount ,
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

Line 920: FROM cn_srp_period_quotas_v spq,

916: IS
917: SELECT COUNT(spq.srp_period_quota_id) interval_count,
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

Line 1493: FROM cn_srp_period_quotas_v spq,

1489: IS
1490: CURSOR period_quotas(l_interval_number NUMBER, l_period_year NUMBER)
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

Line 1517: FROM cn_srp_period_quotas_v spq,

1513: IS
1514: SELECT COUNT(spq.srp_period_quota_id) interval_count,
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