APPS.PSP_ENC_LIQ_TRAN dependencies on PSP_ST_RUN_ID_S

Line 920: SELECT psp_st_run_id_s.nextval

916: CLOSE max_period_cur;
917:
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

Line 946: SELECT psp_st_run_id_s.nextval

942: WHERE enc_control_id = enc_control_rec1.enc_control_id;
943:
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

Line 972: SELECT psp_st_run_id_s.nextval

968: ----commit; Bug 2039196: commented this unnecessary commit.
969: END LOOP;
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;

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;