APPS.CN_SRP_QUOTA_ASSIGNS_PKG dependencies on CN_SRP_PERIOD_QUOTAS_ALL

Line 95: FROM cn_srp_period_quotas_all cspq

91: INTO l_return
92: FROM
93: (
94: SELECT 'X'
95: FROM cn_srp_period_quotas_all cspq
96: , cn_period_quotas_all cpq
97: WHERE cspq.srp_quota_assign_id = x_srp_quota_assign_id
98: AND cpq.quota_id = x_quota_id
99: AND cspq.period_id = cpq.period_id

Line 685: FROM cn_srp_period_quotas_all

681:
682: -- revert srp_period_quota
683: SELECT count(1)
684: INTO l_count
685: FROM cn_srp_period_quotas_all
686: WHERE srp_quota_assign_id = x_srp_quota_assign_id
687: AND rownum = 1
688: ;
689: