DBA Data[Home] [Help]

APPS.PAY_IP_PAYROLL_ARCH dependencies on PER_ALL_PEOPLE_F

Line 240: lv_last_name per_all_people_f.last_name%TYPE;

236: lv_error_message VARCHAR2(200);
237: ln_step NUMBER;
238:
239: lv_action_category pay_action_information.action_information_category%TYPE;
240: lv_last_name per_all_people_f.last_name%TYPE;
241: lv_first_name per_all_people_f.first_name%TYPE;
242: lv_middle_name per_all_people_f.middle_names%TYPE;
243: lv_prefix per_all_people_f.pre_name_adjunct%TYPE;
244: lv_suffix per_all_people_f.suffix%TYPE;

Line 241: lv_first_name per_all_people_f.first_name%TYPE;

237: ln_step NUMBER;
238:
239: lv_action_category pay_action_information.action_information_category%TYPE;
240: lv_last_name per_all_people_f.last_name%TYPE;
241: lv_first_name per_all_people_f.first_name%TYPE;
242: lv_middle_name per_all_people_f.middle_names%TYPE;
243: lv_prefix per_all_people_f.pre_name_adjunct%TYPE;
244: lv_suffix per_all_people_f.suffix%TYPE;
245: lv_title per_all_people_f.title%TYPE;

Line 242: lv_middle_name per_all_people_f.middle_names%TYPE;

238:
239: lv_action_category pay_action_information.action_information_category%TYPE;
240: lv_last_name per_all_people_f.last_name%TYPE;
241: lv_first_name per_all_people_f.first_name%TYPE;
242: lv_middle_name per_all_people_f.middle_names%TYPE;
243: lv_prefix per_all_people_f.pre_name_adjunct%TYPE;
244: lv_suffix per_all_people_f.suffix%TYPE;
245: lv_title per_all_people_f.title%TYPE;
246: lv_known_as per_all_people_f.known_as%TYPE;

Line 243: lv_prefix per_all_people_f.pre_name_adjunct%TYPE;

239: lv_action_category pay_action_information.action_information_category%TYPE;
240: lv_last_name per_all_people_f.last_name%TYPE;
241: lv_first_name per_all_people_f.first_name%TYPE;
242: lv_middle_name per_all_people_f.middle_names%TYPE;
243: lv_prefix per_all_people_f.pre_name_adjunct%TYPE;
244: lv_suffix per_all_people_f.suffix%TYPE;
245: lv_title per_all_people_f.title%TYPE;
246: lv_known_as per_all_people_f.known_as%TYPE;
247: lv_marital_status per_all_people_f.marital_status%TYPE;

Line 244: lv_suffix per_all_people_f.suffix%TYPE;

240: lv_last_name per_all_people_f.last_name%TYPE;
241: lv_first_name per_all_people_f.first_name%TYPE;
242: lv_middle_name per_all_people_f.middle_names%TYPE;
243: lv_prefix per_all_people_f.pre_name_adjunct%TYPE;
244: lv_suffix per_all_people_f.suffix%TYPE;
245: lv_title per_all_people_f.title%TYPE;
246: lv_known_as per_all_people_f.known_as%TYPE;
247: lv_marital_status per_all_people_f.marital_status%TYPE;
248: lv_sex per_all_people_f.sex%TYPE;

Line 245: lv_title per_all_people_f.title%TYPE;

241: lv_first_name per_all_people_f.first_name%TYPE;
242: lv_middle_name per_all_people_f.middle_names%TYPE;
243: lv_prefix per_all_people_f.pre_name_adjunct%TYPE;
244: lv_suffix per_all_people_f.suffix%TYPE;
245: lv_title per_all_people_f.title%TYPE;
246: lv_known_as per_all_people_f.known_as%TYPE;
247: lv_marital_status per_all_people_f.marital_status%TYPE;
248: lv_sex per_all_people_f.sex%TYPE;
249: lv_nationality per_all_people_f.nationality%TYPE;

Line 246: lv_known_as per_all_people_f.known_as%TYPE;

242: lv_middle_name per_all_people_f.middle_names%TYPE;
243: lv_prefix per_all_people_f.pre_name_adjunct%TYPE;
244: lv_suffix per_all_people_f.suffix%TYPE;
245: lv_title per_all_people_f.title%TYPE;
246: lv_known_as per_all_people_f.known_as%TYPE;
247: lv_marital_status per_all_people_f.marital_status%TYPE;
248: lv_sex per_all_people_f.sex%TYPE;
249: lv_nationality per_all_people_f.nationality%TYPE;
250: lv_work_at_home per_all_assignments_f.work_at_home%TYPE;

Line 247: lv_marital_status per_all_people_f.marital_status%TYPE;

243: lv_prefix per_all_people_f.pre_name_adjunct%TYPE;
244: lv_suffix per_all_people_f.suffix%TYPE;
245: lv_title per_all_people_f.title%TYPE;
246: lv_known_as per_all_people_f.known_as%TYPE;
247: lv_marital_status per_all_people_f.marital_status%TYPE;
248: lv_sex per_all_people_f.sex%TYPE;
249: lv_nationality per_all_people_f.nationality%TYPE;
250: lv_work_at_home per_all_assignments_f.work_at_home%TYPE;
251:

Line 248: lv_sex per_all_people_f.sex%TYPE;

244: lv_suffix per_all_people_f.suffix%TYPE;
245: lv_title per_all_people_f.title%TYPE;
246: lv_known_as per_all_people_f.known_as%TYPE;
247: lv_marital_status per_all_people_f.marital_status%TYPE;
248: lv_sex per_all_people_f.sex%TYPE;
249: lv_nationality per_all_people_f.nationality%TYPE;
250: lv_work_at_home per_all_assignments_f.work_at_home%TYPE;
251:
252: ln_index NUMBER;

Line 249: lv_nationality per_all_people_f.nationality%TYPE;

245: lv_title per_all_people_f.title%TYPE;
246: lv_known_as per_all_people_f.known_as%TYPE;
247: lv_marital_status per_all_people_f.marital_status%TYPE;
248: lv_sex per_all_people_f.sex%TYPE;
249: lv_nationality per_all_people_f.nationality%TYPE;
250: lv_work_at_home per_all_assignments_f.work_at_home%TYPE;
251:
252: ln_index NUMBER;
253: