226:
227: --
228: --Get the Segment Values for the Organization Entity
229: --
230: CURSOR cur_or_unit_accts (cp_org_unit_cd igs_or_unit_accts.org_unit_cd%TYPE,
231: cp_start_dt igs_or_unit_accts.start_dt%TYPE)
232: IS
233: SELECT segment_num,segment_value
234: FROM igs_or_unit_accts
227: --
228: --Get the Segment Values for the Organization Entity
229: --
230: CURSOR cur_or_unit_accts (cp_org_unit_cd igs_or_unit_accts.org_unit_cd%TYPE,
231: cp_start_dt igs_or_unit_accts.start_dt%TYPE)
232: IS
233: SELECT segment_num,segment_value
234: FROM igs_or_unit_accts
235: WHERE org_unit_cd = cp_org_unit_cd
230: CURSOR cur_or_unit_accts (cp_org_unit_cd igs_or_unit_accts.org_unit_cd%TYPE,
231: cp_start_dt igs_or_unit_accts.start_dt%TYPE)
232: IS
233: SELECT segment_num,segment_value
234: FROM igs_or_unit_accts
235: WHERE org_unit_cd = cp_org_unit_cd
236: AND start_dt = cp_start_dt;
237:
238: --