120: l_ss_number per_all_people_f.NATIONAL_IDENTIFIER%type;
121: l_mandatory varchar2(1);
122: l_conditional varchar2(1);
123: l_optional varchar2(1);
124: l_nationality fnd_lookup_values.meaning%type;
125: --checks whether any employee is there in a establishment
126: l_emp_found boolean;
127:
128: Begin