[Home] [Help]
1033:
1034: -- Cursor to get the start date of the organization
1035: CURSOR c_org_date IS
1036: SELECT start_dt
1037: FROM igs_or_unit
1038: WHERE org_unit_cd = p_org_unit_cd;
1039:
1040: l_start_dt igs_or_unit.start_dt%TYPE;
1041:
1036: SELECT start_dt
1037: FROM igs_or_unit
1038: WHERE org_unit_cd = p_org_unit_cd;
1039:
1040: l_start_dt igs_or_unit.start_dt%TYPE;
1041:
1042: BEGIN
1043:
1044: OPEN c_org_date;