1701: l_Record_Type VARCHAR2(1):='A';
1702: BEGIN
1703: FOR cur_Projects_List IN (SELECT DISTINCT prj.name name
1704: FROM pji_rm_res_wt_f fct 1705: ,pa_projects_all prj 1706: WHERE
1707: prj.project_id = fct.project_id
1708: AND fct.person_id = p_Person_ID
1709: AND fct.time_id = l_Time_ID