DBA Data[Home] [Help]

APPS.PAY_GB_RTI_FPS_VALIDATE_13 dependencies on PER_PEOPLE_F

Line 253: l_last_name per_people_f.last_name%TYPE;

249: l_postal_code per_addresses.postal_code%TYPE;
250: l_country per_addresses.country%TYPE;
251:
252: -- Person details
253: l_last_name per_people_f.last_name%TYPE;
254: l_first_name per_people_f.first_name%TYPE;
255: l_middle_name per_people_f.middle_names%TYPE;
256: l_national_identifier per_people_f.national_identifier%TYPE;
257: l_title per_people_f.title%TYPE;

Line 254: l_first_name per_people_f.first_name%TYPE;

250: l_country per_addresses.country%TYPE;
251:
252: -- Person details
253: l_last_name per_people_f.last_name%TYPE;
254: l_first_name per_people_f.first_name%TYPE;
255: l_middle_name per_people_f.middle_names%TYPE;
256: l_national_identifier per_people_f.national_identifier%TYPE;
257: l_title per_people_f.title%TYPE;
258: l_date_of_birth per_people_f.date_of_birth%TYPE;

Line 255: l_middle_name per_people_f.middle_names%TYPE;

251:
252: -- Person details
253: l_last_name per_people_f.last_name%TYPE;
254: l_first_name per_people_f.first_name%TYPE;
255: l_middle_name per_people_f.middle_names%TYPE;
256: l_national_identifier per_people_f.national_identifier%TYPE;
257: l_title per_people_f.title%TYPE;
258: l_date_of_birth per_people_f.date_of_birth%TYPE;
259: l_sex per_people_f.sex%TYPE;

Line 256: l_national_identifier per_people_f.national_identifier%TYPE;

252: -- Person details
253: l_last_name per_people_f.last_name%TYPE;
254: l_first_name per_people_f.first_name%TYPE;
255: l_middle_name per_people_f.middle_names%TYPE;
256: l_national_identifier per_people_f.national_identifier%TYPE;
257: l_title per_people_f.title%TYPE;
258: l_date_of_birth per_people_f.date_of_birth%TYPE;
259: l_sex per_people_f.sex%TYPE;
260: l_passport_no varchar2(50);

Line 257: l_title per_people_f.title%TYPE;

253: l_last_name per_people_f.last_name%TYPE;
254: l_first_name per_people_f.first_name%TYPE;
255: l_middle_name per_people_f.middle_names%TYPE;
256: l_national_identifier per_people_f.national_identifier%TYPE;
257: l_title per_people_f.title%TYPE;
258: l_date_of_birth per_people_f.date_of_birth%TYPE;
259: l_sex per_people_f.sex%TYPE;
260: l_passport_no varchar2(50);
261:

Line 258: l_date_of_birth per_people_f.date_of_birth%TYPE;

254: l_first_name per_people_f.first_name%TYPE;
255: l_middle_name per_people_f.middle_names%TYPE;
256: l_national_identifier per_people_f.national_identifier%TYPE;
257: l_title per_people_f.title%TYPE;
258: l_date_of_birth per_people_f.date_of_birth%TYPE;
259: l_sex per_people_f.sex%TYPE;
260: l_passport_no varchar2(50);
261:
262: -- Partner Person Details

Line 259: l_sex per_people_f.sex%TYPE;

255: l_middle_name per_people_f.middle_names%TYPE;
256: l_national_identifier per_people_f.national_identifier%TYPE;
257: l_title per_people_f.title%TYPE;
258: l_date_of_birth per_people_f.date_of_birth%TYPE;
259: l_sex per_people_f.sex%TYPE;
260: l_passport_no varchar2(50);
261:
262: -- Partner Person Details
263: l_partner_last_name per_people_f.last_name%TYPE;

Line 263: l_partner_last_name per_people_f.last_name%TYPE;

259: l_sex per_people_f.sex%TYPE;
260: l_passport_no varchar2(50);
261:
262: -- Partner Person Details
263: l_partner_last_name per_people_f.last_name%TYPE;
264: l_partner_first_name per_people_f.first_name%TYPE;
265: l_partner_middle_name per_people_f.middle_names%TYPE;
266: l_partner_national_id per_people_f.national_identifier%TYPE;
267:

Line 264: l_partner_first_name per_people_f.first_name%TYPE;

260: l_passport_no varchar2(50);
261:
262: -- Partner Person Details
263: l_partner_last_name per_people_f.last_name%TYPE;
264: l_partner_first_name per_people_f.first_name%TYPE;
265: l_partner_middle_name per_people_f.middle_names%TYPE;
266: l_partner_national_id per_people_f.national_identifier%TYPE;
267:
268: -- Assignment Details required for validations

Line 265: l_partner_middle_name per_people_f.middle_names%TYPE;

261:
262: -- Partner Person Details
263: l_partner_last_name per_people_f.last_name%TYPE;
264: l_partner_first_name per_people_f.first_name%TYPE;
265: l_partner_middle_name per_people_f.middle_names%TYPE;
266: l_partner_national_id per_people_f.national_identifier%TYPE;
267:
268: -- Assignment Details required for validations
269: l_aspp number;

Line 266: l_partner_national_id per_people_f.national_identifier%TYPE;

262: -- Partner Person Details
263: l_partner_last_name per_people_f.last_name%TYPE;
264: l_partner_first_name per_people_f.first_name%TYPE;
265: l_partner_middle_name per_people_f.middle_names%TYPE;
266: l_partner_national_id per_people_f.national_identifier%TYPE;
267:
268: -- Assignment Details required for validations
269: l_aspp number;
270: l_start_date date;

Line 525: l_last_name per_people_f.last_name%TYPE;

521: l_postal_code per_addresses.postal_code%TYPE;
522: l_country per_addresses.country%TYPE;
523:
524: -- Person details
525: l_last_name per_people_f.last_name%TYPE;
526: l_first_name per_people_f.first_name%TYPE;
527: l_middle_name per_people_f.middle_names%TYPE;
528: l_national_identifier per_people_f.national_identifier%TYPE;
529: l_title per_people_f.title%TYPE;

Line 526: l_first_name per_people_f.first_name%TYPE;

522: l_country per_addresses.country%TYPE;
523:
524: -- Person details
525: l_last_name per_people_f.last_name%TYPE;
526: l_first_name per_people_f.first_name%TYPE;
527: l_middle_name per_people_f.middle_names%TYPE;
528: l_national_identifier per_people_f.national_identifier%TYPE;
529: l_title per_people_f.title%TYPE;
530: l_date_of_birth per_people_f.date_of_birth%TYPE;

Line 527: l_middle_name per_people_f.middle_names%TYPE;

523:
524: -- Person details
525: l_last_name per_people_f.last_name%TYPE;
526: l_first_name per_people_f.first_name%TYPE;
527: l_middle_name per_people_f.middle_names%TYPE;
528: l_national_identifier per_people_f.national_identifier%TYPE;
529: l_title per_people_f.title%TYPE;
530: l_date_of_birth per_people_f.date_of_birth%TYPE;
531: l_sex per_people_f.sex%TYPE;

Line 528: l_national_identifier per_people_f.national_identifier%TYPE;

524: -- Person details
525: l_last_name per_people_f.last_name%TYPE;
526: l_first_name per_people_f.first_name%TYPE;
527: l_middle_name per_people_f.middle_names%TYPE;
528: l_national_identifier per_people_f.national_identifier%TYPE;
529: l_title per_people_f.title%TYPE;
530: l_date_of_birth per_people_f.date_of_birth%TYPE;
531: l_sex per_people_f.sex%TYPE;
532: l_passport_no varchar2(50);

Line 529: l_title per_people_f.title%TYPE;

525: l_last_name per_people_f.last_name%TYPE;
526: l_first_name per_people_f.first_name%TYPE;
527: l_middle_name per_people_f.middle_names%TYPE;
528: l_national_identifier per_people_f.national_identifier%TYPE;
529: l_title per_people_f.title%TYPE;
530: l_date_of_birth per_people_f.date_of_birth%TYPE;
531: l_sex per_people_f.sex%TYPE;
532: l_passport_no varchar2(50);
533:

Line 530: l_date_of_birth per_people_f.date_of_birth%TYPE;

526: l_first_name per_people_f.first_name%TYPE;
527: l_middle_name per_people_f.middle_names%TYPE;
528: l_national_identifier per_people_f.national_identifier%TYPE;
529: l_title per_people_f.title%TYPE;
530: l_date_of_birth per_people_f.date_of_birth%TYPE;
531: l_sex per_people_f.sex%TYPE;
532: l_passport_no varchar2(50);
533:
534: -- Partner Person Details

Line 531: l_sex per_people_f.sex%TYPE;

527: l_middle_name per_people_f.middle_names%TYPE;
528: l_national_identifier per_people_f.national_identifier%TYPE;
529: l_title per_people_f.title%TYPE;
530: l_date_of_birth per_people_f.date_of_birth%TYPE;
531: l_sex per_people_f.sex%TYPE;
532: l_passport_no varchar2(50);
533:
534: -- Partner Person Details
535: l_partner_last_name per_people_f.last_name%TYPE;

Line 535: l_partner_last_name per_people_f.last_name%TYPE;

531: l_sex per_people_f.sex%TYPE;
532: l_passport_no varchar2(50);
533:
534: -- Partner Person Details
535: l_partner_last_name per_people_f.last_name%TYPE;
536: l_partner_first_name per_people_f.first_name%TYPE;
537: l_partner_middle_name per_people_f.middle_names%TYPE;
538: l_partner_national_id per_people_f.national_identifier%TYPE;
539:

Line 536: l_partner_first_name per_people_f.first_name%TYPE;

532: l_passport_no varchar2(50);
533:
534: -- Partner Person Details
535: l_partner_last_name per_people_f.last_name%TYPE;
536: l_partner_first_name per_people_f.first_name%TYPE;
537: l_partner_middle_name per_people_f.middle_names%TYPE;
538: l_partner_national_id per_people_f.national_identifier%TYPE;
539:
540: -- Assignment Details required for validations

Line 537: l_partner_middle_name per_people_f.middle_names%TYPE;

533:
534: -- Partner Person Details
535: l_partner_last_name per_people_f.last_name%TYPE;
536: l_partner_first_name per_people_f.first_name%TYPE;
537: l_partner_middle_name per_people_f.middle_names%TYPE;
538: l_partner_national_id per_people_f.national_identifier%TYPE;
539:
540: -- Assignment Details required for validations
541: l_aspp number;

Line 538: l_partner_national_id per_people_f.national_identifier%TYPE;

534: -- Partner Person Details
535: l_partner_last_name per_people_f.last_name%TYPE;
536: l_partner_first_name per_people_f.first_name%TYPE;
537: l_partner_middle_name per_people_f.middle_names%TYPE;
538: l_partner_national_id per_people_f.national_identifier%TYPE;
539:
540: -- Assignment Details required for validations
541: l_aspp number;
542: l_start_date date;