APPS.PSP_SUM_ADJ dependencies on DUAL

Line 310: FROM DUAL;

306: -- Replaced the following lines of code for bug fix 1769610 and included new set of codes
307:
308: SELECT psp_st_run_id_s.nextval
309: INTO g_run_id
310: FROM DUAL;
311:
312:
313: --- 2444657: derive run-mode
314: open derive_run_mode;

Line 1082: FROM DUAL;

1078:
1079:
1080: SELECT PSP_SUMMARY_LINES_S.NEXTVAL
1081: INTO P_SUMMARY_LINE_ID
1082: FROM DUAL;
1083:
1084: INSERT INTO PSP_SUMMARY_LINES(
1085: SUMMARY_LINE_ID,
1086: PERSON_ID,

Line 1350: FROM DUAL;

1346: end if;
1347: -- get the group_id. Moved the group id out of payroll control id loop. Bug 1977939
1348: SELECT gl_interface_control_s.nextval
1349: INTO l_group_id
1350: FROM DUAL;
1351:
1352: l_rec_count := 0; -- MOVED this stmt, from inside the payroll control loop id Bug 1977939.
1353: OPEN gl_batch_cursor(pc_batch_rec.batch_name);
1354: LOOP

Line 1489: FROM DUAL;

1485:
1486: -- insert into gl_interface_control
1487: SELECT GL_JOURNAL_IMPORT_S.NEXTVAL
1488: INTO l_int_run_id
1489: FROM DUAL;
1490:
1491: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Calling insert_into_gl_interface ');
1492:
1493: insert into gl_interface_control(

Line 3066: FROM dual;

3062: FOR i in 1..org_id_tab.count
3063: LOOP
3064: SELECT to_char(psp_gms_batch_name_s.nextval)
3065: INTO gms_batch_name_tab(i)
3066: FROM dual;
3067: END LOOP;
3068: /*
3069: -- get the gms_batch_name for the summary batch
3070: SELECT to_char(psp_gms_batch_name_s.nextval)

Line 3072: FROM DUAL;

3068: /*
3069: -- get the gms_batch_name for the summary batch
3070: SELECT to_char(psp_gms_batch_name_s.nextval)
3071: INTO l_gms_batch_name
3072: FROM DUAL;
3073: */
3074: OPEN pc_batch_cur;
3075: LOOP
3076: FETCH pc_batch_cur into pc_batch_rec;

Line 3309: from dual;

3305: l_rec_count := l_rec_count + 1;
3306:
3307: select pa_txn_interface_s.nextval
3308: into l_txn_interface_id
3309: from dual;
3310:
3311: -- set the context to single to call pa_utils function
3312: mo_global.set_policy_context('S', gms_interface_rec.org_id );
3313:

Line 3472: FROM DUAL;

3468: -- Bug 6902514 Start
3469:
3470: SELECT to_char(psp_gms_batch_name_s.nextval)
3471: INTO l_gms_stat_batch_name
3472: FROM DUAL;
3473:
3474: UPDATE pa_transaction_interface_all
3475: SET BATCH_NAME = l_gms_stat_batch_name
3476: where DENOM_CURRENCY_CODE = 'STAT'

Line 4993: FROM DUAL;

4989: l_msg_id number(9);
4990: BEGIN
4991: SELECT PSP_STOUT_S.NEXTVAL
4992: INTO l_msg_id
4993: FROM DUAL;
4994:
4995: INSERT INTO PSP_STOUT(
4996: MSG_ID,
4997: MSG)