APPS.PSP_ENC_LIQ_TRAN dependencies on DUAL

Line 922: FROM dual;

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

Line 948: FROM dual;

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

Line 974: FROM dual;

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

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

997:
998: --COMMIT:
999: End of Comment for bug fix 4625734 *****/
1000:
1001: SELECT psp_st_run_id_s.nextval INTO g_run_id FROM dual;
1002: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' g_run_id: '||g_run_id);
1003: OPEN payroll_id_cur;
1004: LOOP
1005: FETCH payroll_id_cur INTO l_payroll_id;

Line 2538: FROM DUAL;

2534: ) IS
2535: BEGIN
2536: SELECT PSP_ENC_SUMMARY_LINES_S.NEXTVAL
2537: INTO P_ENC_SUMMARY_LINE_ID
2538: FROM DUAL;
2539: INSERT INTO PSP_ENC_SUMMARY_LINES(
2540: ENC_SUMMARY_LINE_ID,
2541: BUSINESS_GROUP_ID,
2542: ENC_CONTROL_ID,

Line 2825: FROM dual;

2821: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_enc_type_id: ' || l_enc_type_id);
2822:
2823: SELECT gl_interface_control_s.nextval
2824: INTO l_group_id
2825: FROM dual;
2826:
2827: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_group_id: ' || l_group_id);
2828:
2829:

Line 3077: FROM dual;

3073: -- insert into psp_stout values(91, 'kicking gl journal import');
3074:
3075: SELECT GL_JOURNAL_IMPORT_S.NEXTVAL
3076: INTO l_int_run_id
3077: FROM dual;
3078:
3079: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_int_run_id: ' || l_int_run_id);
3080:
3081: insert into gl_interface_control(

Line 5312: FROM dual; *****/

5308:
5309:
5310: /***** SELECT to_char(psp_gms_batch_name_s.nextval)
5311: INTO g_gms_batch_name --- replaced with global for 3473294
5312: FROM dual; *****/
5313:
5314: FOR I in 1..org_id_tab.count
5315: LOOP
5316: SELECT to_char(psp_gms_batch_name_s.nextval)

Line 5318: FROM dual;

5314: FOR I in 1..org_id_tab.count
5315: LOOP
5316: SELECT to_char(psp_gms_batch_name_s.nextval)
5317: INTO gms_batch_name_tab(i)
5318: FROM dual;
5319: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' gms_batch_name_tab(' || I || '): ' || gms_batch_name_tab(i));
5320: END LOOP;
5321:
5322:

Line 5708: from dual;

5704: -- Get the transaction_interface_id. We need this to populate the gms_interface table.
5705:
5706: select pa_txn_interface_s.nextval
5707: into l_txn_interface_id
5708: from dual;
5709: ------Bug 2039196: Swapped the order of PA/GMS population
5710: -- dbms_output.put_line('Inserting into pa interface.............');
5711:
5712: -- if int_rec.award_id is not null then Commented for bug fix 2908859

Line 7137: FROM DUAL;

7133: l_msg_id number(9);
7134: BEGIN
7135: SELECT PSP_STOUT_S.NEXTVAL
7136: INTO l_msg_id
7137: FROM DUAL;
7138: INSERT INTO PSP_STOUT(
7139: MSG_ID,
7140: MSG)
7141: VALUES(