DBA Data[Home] [Help]

APPS.IGS_PS_GEN_001 dependencies on IGS_PS_OFR_PAT_COP_ID_S

Line 408: SELECT IGS_PS_OFR_PAT_COP_ID_S.NEXTVAL

404: FROM IGS_AS_GRD_SCHEMA gs
405: WHERE gs.grading_schema_cd = cp_gs_cd;
406: BEGIN
407: -- select the next sequence_number from the system
408: SELECT IGS_PS_OFR_PAT_COP_ID_S.NEXTVAL
409: INTO gv_cop_seq_num
410: FROM DUAL;
411: -- get the latest grading schema version number
412: OPEN c_latest_gs_version (