|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
open cursor with hold l_cursor for select pas~guid from ( loyd_pt_acct_set as pas inner join loyd_pt_acct as pa on pa~ref_guid = pas~guid ) for all entries in lt_membership where pas~program_guid = lv_guid and pas~istat = cl_loy_pt_acct_constants=>gc_active and pas~guid = lt_membership-pa_set_guid and pa~balance > 0. do. fetch next cursor l_cursor into table lt_pt_acct_set_guid package size lv_batch_size. enddo. close cursor l_cursor. |
