[Home] [Help]
1116: IS
1117:
1118: CURSOR csr_appl_date IS
1119: SELECT date_received
1120: FROM per_applications
1121: WHERE person_id(+) = p_person_id
1122: AND (date_end is null);
1123:
1124: l_date_received per_applications.date_received%type;
1120: FROM per_applications
1121: WHERE person_id(+) = p_person_id
1122: AND (date_end is null);
1123:
1124: l_date_received per_applications.date_received%type;
1125:
1126: BEGIN
1127:
1128: OPEN csr_appl_date;