DBA Data[Home] [Help]

APPS.CN_SRP_QUOTA_ASSIGNS_PKG dependencies on CN_ROLLOVER_QUOTAS_ALL

Line 244: FROM cn_rollover_quotas_all

240: l_srp_quota_assign_c2 l_srp_quota_assign_csr2%ROWTYPE;
241:
242: CURSOR l_rollover_quota_csr (c_quota_id cn_quotas.quota_id%TYPE) IS
243: SELECT *
244: FROM cn_rollover_quotas_all
245: WHERE quota_id = c_quota_id;
246:
247: l_rollover_quota_c l_rollover_quota_csr%ROWTYPE;
248:

Line 653: from cn_rollover_quotas_all crq

649:
650: update cn_srp_rollover_quotas_all csrq
651: set rollover =
652: ( select rollover
653: from cn_rollover_quotas_all crq
654: where crq.rollover_quota_id = l_srp_rollover_quota.rollover_quota_id)
655: where srp_rollover_quota_id = l_srp_rollover_quota.srp_rollover_quota_id;
656: END LOOP;
657: