370: p_assignment_id NUMBER;
371: l_person_id NUMBER;
372: l_profile_date_string VARCHAR2(40);
373: /* 6500188 */
374: l_first_name per_all_people_f.first_name%type;
375: l_middle_name per_all_people_f.middle_names%type;
376: l_dummy varchar2(100);
377: l_full_name per_all_people_f.full_name%type;
378: l_nj_sdi1_value varchar2(20) ;
371: l_person_id NUMBER;
372: l_profile_date_string VARCHAR2(40);
373: /* 6500188 */
374: l_first_name per_all_people_f.first_name%type;
375: l_middle_name per_all_people_f.middle_names%type;
376: l_dummy varchar2(100);
377: l_full_name per_all_people_f.full_name%type;
378: l_nj_sdi1_value varchar2(20) ;
379: l_flipp_id varchar2(20) ;
373: /* 6500188 */
374: l_first_name per_all_people_f.first_name%type;
375: l_middle_name per_all_people_f.middle_names%type;
376: l_dummy varchar2(100);
377: l_full_name per_all_people_f.full_name%type;
378: l_nj_sdi1_value varchar2(20) ;
379: l_flipp_id varchar2(20) ;
380: l_state_zero_flag varchar2(10) ;
381: