APPS.PSP_ENC_LIQ_TRAN dependencies on DUAL

Line 920: FROM dual;

916: IF
917: p_action_type = 'L' THEN
918: SELECT psp_st_run_id_s.nextval
919: INTO g_run_id
920: FROM dual;
921: OPEN enc_control_cur1(l_max_time_period);
922: LOOP
923: FETCH enc_control_cur1 INTO enc_control_rec1;
924: IF enc_control_cur1%rowcount = 0

Line 946: FROM dual;

942: END LOOP;
943: ELSIF p_action_type IN ('U', 'Q') THEN -- Included 'Q' for Enh. 2143723
944: SELECT psp_st_run_id_s.nextval
945: INTO g_run_id
946: FROM dual;
947: OPEN enc_control_cur2(l_max_time_period);
948: LOOP
949: FETCH enc_control_cur2 INTO enc_control_rec2;
950: IF enc_control_cur2%rowcount = 0

Line 972: FROM dual;

968: END IF;
969: else --- introduced else for 3413373
970: SELECT psp_st_run_id_s.nextval
971: INTO g_run_id
972: FROM dual;
973:
974: OPEN enc_control_cur3;
975: LOOP
976: FETCH enc_control_cur3 INTO enc_control_rec3;

Line 999: SELECT psp_st_run_id_s.nextval INTO g_run_id FROM dual;

995:
996: --COMMIT:
997: End of Comment for bug fix 4625734 *****/
998:
999: SELECT psp_st_run_id_s.nextval INTO g_run_id FROM dual;
1000:
1001: OPEN payroll_id_cur;
1002: LOOP
1003: FETCH payroll_id_cur INTO l_payroll_id;

Line 2485: FROM DUAL;

2481: ) IS
2482: BEGIN
2483: SELECT PSP_ENC_SUMMARY_LINES_S.NEXTVAL
2484: INTO P_ENC_SUMMARY_LINE_ID
2485: FROM DUAL;
2486: INSERT INTO PSP_ENC_SUMMARY_LINES(
2487: ENC_SUMMARY_LINE_ID,
2488: BUSINESS_GROUP_ID,
2489: ENC_CONTROL_ID,

Line 2772: FROM dual;

2768: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_enc_type_id: ' || l_enc_type_id);
2769:
2770: SELECT gl_interface_control_s.nextval
2771: INTO l_group_id
2772: FROM dual;
2773:
2774: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_group_id: ' || l_group_id);
2775:
2776: UPDATE psp_enc_summary_lines

Line 3024: FROM dual;

3020: -- insert into psp_stout values(91, 'kicking gl journal import');
3021:
3022: SELECT GL_JOURNAL_IMPORT_S.NEXTVAL
3023: INTO l_int_run_id
3024: FROM dual;
3025:
3026: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_int_run_id: ' || l_int_run_id);
3027:
3028: insert into gl_interface_control(

Line 5244: FROM dual; *****/

5240:
5241:
5242: /***** SELECT to_char(psp_gms_batch_name_s.nextval)
5243: INTO g_gms_batch_name --- replaced with global for 3473294
5244: FROM dual; *****/
5245:
5246: FOR I in 1..org_id_tab.count
5247: LOOP
5248: SELECT to_char(psp_gms_batch_name_s.nextval)

Line 5250: FROM dual;

5246: FOR I in 1..org_id_tab.count
5247: LOOP
5248: SELECT to_char(psp_gms_batch_name_s.nextval)
5249: INTO gms_batch_name_tab(i)
5250: FROM dual;
5251: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || 'gms_batch_name_tab(' || I || '): ' || gms_batch_name_tab(i));
5252: END LOOP;
5253:
5254:

Line 5613: from dual;

5609: -- Get the transaction_interface_id. We need this to populate the gms_interface table.
5610:
5611: select pa_txn_interface_s.nextval
5612: into l_txn_interface_id
5613: from dual;
5614: ------Bug 2039196: Swapped the order of PA/GMS population
5615: -- dbms_output.put_line('Inserting into pa interface.............');
5616:
5617: -- if int_rec.award_id is not null then Commented for bug fix 2908859

Line 6899: FROM DUAL;

6895: l_msg_id number(9);
6896: BEGIN
6897: SELECT PSP_STOUT_S.NEXTVAL
6898: INTO l_msg_id
6899: FROM DUAL;
6900: INSERT INTO PSP_STOUT(
6901: MSG_ID,
6902: MSG)
6903: VALUES(