366: p_assignment_id NUMBER;
367: l_person_id NUMBER;
368: l_profile_date_string VARCHAR2(40);
369: /* 6500188 */
370: l_first_name per_all_people_f.first_name%type;
371: l_middle_name per_all_people_f.middle_names%type;
372: l_dummy varchar2(100);
373: l_full_name per_all_people_f.full_name%type;
374:
367: l_person_id NUMBER;
368: l_profile_date_string VARCHAR2(40);
369: /* 6500188 */
370: l_first_name per_all_people_f.first_name%type;
371: l_middle_name per_all_people_f.middle_names%type;
372: l_dummy varchar2(100);
373: l_full_name per_all_people_f.full_name%type;
374:
375:
369: /* 6500188 */
370: l_first_name per_all_people_f.first_name%type;
371: l_middle_name per_all_people_f.middle_names%type;
372: l_dummy varchar2(100);
373: l_full_name per_all_people_f.full_name%type;
374:
375:
376:
377: -- PROCEDURE get_employee_info (p_asg_action_id NUMBER) IS