APPS.PSP_SUM_TRANS dependencies on PSP_GMS_BATCH_NAME_S

Line 3657: SELECT to_char(psp_gms_batch_name_s.nextval)

3653: IF gms_batch_rec.phase = 'Summarize_GMS_Lines' then --2444657
3654:
3655: FOR I in 1..org_id_tab.count
3656: LOOP
3657: SELECT to_char(psp_gms_batch_name_s.nextval)
3658: INTO gms_batch_name_tab(i)
3659: FROM dual;
3660: END LOOP;
3661: /*

Line 3663: SELECT to_char(psp_gms_batch_name_s.nextval)

3659: FROM dual;
3660: END LOOP;
3661: /*
3662: -- get the group_id
3663: SELECT to_char(psp_gms_batch_name_s.nextval)
3664: INTO l_gms_batch_name
3665: FROM dual;
3666: */
3667: -- R12 MOAC Uptake. Moved this code to loop