580: l_recinfo sqr_curs%ROWTYPE;
581:
582: CURSOR srp_rollover_quota_curs IS
583: SELECT *
584: FROM cn_srp_rollover_quotas_all
585: WHERE srp_quota_assign_id = x_srp_quota_assign_id;
586:
587: l_srp_rollover_quota srp_rollover_quota_curs%ROWTYPE;
588:
646: -- clku, revert changes in cn_srp_rolling_quotas
647:
648: FOR l_srp_rollover_quota IN srp_rollover_quota_curs LOOP
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)
900: recinfo srp_quota_curs%ROWTYPE;
901:
902: CURSOR l_srp_rollover_quota_csr (c_srp_quota_assign_id cn_srp_quota_assigns.srp_quota_assign_id%TYPE) IS
903: SELECT *
904: FROM cn_srp_rollover_quotas_all
905: WHERE srp_quota_assign_id = c_srp_quota_assign_id;
906:
907: l_srp_rollover_quota_c l_srp_rollover_quota_csr%ROWTYPE;
908: