APPS.PSP_ENC_LIQ_TRAN dependencies on PSP_ST_RUN_ID_S

Line 918: SELECT psp_st_run_id_s.nextval

914: CLOSE max_period_cur;
915:
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

Line 944: SELECT psp_st_run_id_s.nextval

940: WHERE enc_control_id = enc_control_rec1.enc_control_id;
941:
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

Line 970: SELECT psp_st_run_id_s.nextval

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

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;