[Home] [Help]
1140: IS
1141:
1142: CURSOR csr_emp_start_date IS
1143: SELECT date_start
1144: FROM per_periods_of_service
1145: WHERE period_of_service_id(+) = p_period_of_service_id;
1146:
1147: l_date_start per_periods_of_service.date_start%type;
1148:
1143: SELECT date_start
1144: FROM per_periods_of_service
1145: WHERE period_of_service_id(+) = p_period_of_service_id;
1146:
1147: l_date_start per_periods_of_service.date_start%type;
1148:
1149: BEGIN
1150:
1151: OPEN csr_emp_start_date;