206:
207: --
208: --Get the Segment Values for the Unit Entity
209: --
210: CURSOR cur_ps_unit_accts (cp_unit_cd igs_ps_unit_accts.unit_cd%TYPE,
211: cp_version_number igs_ps_unit_accts.version_number%TYPE)
212: IS
213: SELECT segment_num,segment_value
214: FROM igs_ps_unit_accts
207: --
208: --Get the Segment Values for the Unit Entity
209: --
210: CURSOR cur_ps_unit_accts (cp_unit_cd igs_ps_unit_accts.unit_cd%TYPE,
211: cp_version_number igs_ps_unit_accts.version_number%TYPE)
212: IS
213: SELECT segment_num,segment_value
214: FROM igs_ps_unit_accts
215: WHERE unit_cd= cp_unit_cd
210: CURSOR cur_ps_unit_accts (cp_unit_cd igs_ps_unit_accts.unit_cd%TYPE,
211: cp_version_number igs_ps_unit_accts.version_number%TYPE)
212: IS
213: SELECT segment_num,segment_value
214: FROM igs_ps_unit_accts
215: WHERE unit_cd= cp_unit_cd
216: AND version_number = cp_version_number;
217:
218: --