eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_RTI_FPS_VALIDATE dependencies on PER_PEOPLE_F

Line 240: l_last_name per_people_f.last_name%TYPE;

236: l_postal_code per_addresses.postal_code%TYPE;
237: l_country per_addresses.country%TYPE;
238:
239: -- Person details
240: l_last_name per_people_f.last_name%TYPE;
241: l_first_name per_people_f.first_name%TYPE;
242: l_middle_name per_people_f.middle_names%TYPE;
243: l_national_identifier per_people_f.national_identifier%TYPE;
244: l_title per_people_f.title%TYPE;

Line 241: l_first_name per_people_f.first_name%TYPE;

237: l_country per_addresses.country%TYPE;
238:
239: -- Person details
240: l_last_name per_people_f.last_name%TYPE;
241: l_first_name per_people_f.first_name%TYPE;
242: l_middle_name per_people_f.middle_names%TYPE;
243: l_national_identifier per_people_f.national_identifier%TYPE;
244: l_title per_people_f.title%TYPE;
245: l_date_of_birth per_people_f.date_of_birth%TYPE;

Line 242: l_middle_name per_people_f.middle_names%TYPE;

238:
239: -- Person details
240: l_last_name per_people_f.last_name%TYPE;
241: l_first_name per_people_f.first_name%TYPE;
242: l_middle_name per_people_f.middle_names%TYPE;
243: l_national_identifier per_people_f.national_identifier%TYPE;
244: l_title per_people_f.title%TYPE;
245: l_date_of_birth per_people_f.date_of_birth%TYPE;
246: l_sex per_people_f.sex%TYPE;

Line 243: l_national_identifier per_people_f.national_identifier%TYPE;

239: -- Person details
240: l_last_name per_people_f.last_name%TYPE;
241: l_first_name per_people_f.first_name%TYPE;
242: l_middle_name per_people_f.middle_names%TYPE;
243: l_national_identifier per_people_f.national_identifier%TYPE;
244: l_title per_people_f.title%TYPE;
245: l_date_of_birth per_people_f.date_of_birth%TYPE;
246: l_sex per_people_f.sex%TYPE;
247: l_passport_no varchar2(50);

Line 244: l_title per_people_f.title%TYPE;

240: l_last_name per_people_f.last_name%TYPE;
241: l_first_name per_people_f.first_name%TYPE;
242: l_middle_name per_people_f.middle_names%TYPE;
243: l_national_identifier per_people_f.national_identifier%TYPE;
244: l_title per_people_f.title%TYPE;
245: l_date_of_birth per_people_f.date_of_birth%TYPE;
246: l_sex per_people_f.sex%TYPE;
247: l_passport_no varchar2(50);
248:

Line 245: l_date_of_birth per_people_f.date_of_birth%TYPE;

241: l_first_name per_people_f.first_name%TYPE;
242: l_middle_name per_people_f.middle_names%TYPE;
243: l_national_identifier per_people_f.national_identifier%TYPE;
244: l_title per_people_f.title%TYPE;
245: l_date_of_birth per_people_f.date_of_birth%TYPE;
246: l_sex per_people_f.sex%TYPE;
247: l_passport_no varchar2(50);
248:
249: -- Partner Person Details

Line 246: l_sex per_people_f.sex%TYPE;

242: l_middle_name per_people_f.middle_names%TYPE;
243: l_national_identifier per_people_f.national_identifier%TYPE;
244: l_title per_people_f.title%TYPE;
245: l_date_of_birth per_people_f.date_of_birth%TYPE;
246: l_sex per_people_f.sex%TYPE;
247: l_passport_no varchar2(50);
248:
249: -- Partner Person Details
250: l_partner_last_name per_people_f.last_name%TYPE;

Line 250: l_partner_last_name per_people_f.last_name%TYPE;

246: l_sex per_people_f.sex%TYPE;
247: l_passport_no varchar2(50);
248:
249: -- Partner Person Details
250: l_partner_last_name per_people_f.last_name%TYPE;
251: l_partner_first_name per_people_f.first_name%TYPE;
252: l_partner_middle_name per_people_f.middle_names%TYPE;
253: l_partner_national_id per_people_f.national_identifier%TYPE;
254:

Line 251: l_partner_first_name per_people_f.first_name%TYPE;

247: l_passport_no varchar2(50);
248:
249: -- Partner Person Details
250: l_partner_last_name per_people_f.last_name%TYPE;
251: l_partner_first_name per_people_f.first_name%TYPE;
252: l_partner_middle_name per_people_f.middle_names%TYPE;
253: l_partner_national_id per_people_f.national_identifier%TYPE;
254:
255: -- Assignment Details required for validations

Line 252: l_partner_middle_name per_people_f.middle_names%TYPE;

248:
249: -- Partner Person Details
250: l_partner_last_name per_people_f.last_name%TYPE;
251: l_partner_first_name per_people_f.first_name%TYPE;
252: l_partner_middle_name per_people_f.middle_names%TYPE;
253: l_partner_national_id per_people_f.national_identifier%TYPE;
254:
255: -- Assignment Details required for validations
256: l_aspp number;

Line 253: l_partner_national_id per_people_f.national_identifier%TYPE;

249: -- Partner Person Details
250: l_partner_last_name per_people_f.last_name%TYPE;
251: l_partner_first_name per_people_f.first_name%TYPE;
252: l_partner_middle_name per_people_f.middle_names%TYPE;
253: l_partner_national_id per_people_f.national_identifier%TYPE;
254:
255: -- Assignment Details required for validations
256: l_aspp number;
257: l_start_date date;

Line 512: l_last_name per_people_f.last_name%TYPE;

508: l_postal_code per_addresses.postal_code%TYPE;
509: l_country per_addresses.country%TYPE;
510:
511: -- Person details
512: l_last_name per_people_f.last_name%TYPE;
513: l_first_name per_people_f.first_name%TYPE;
514: l_middle_name per_people_f.middle_names%TYPE;
515: l_national_identifier per_people_f.national_identifier%TYPE;
516: l_title per_people_f.title%TYPE;

Line 513: l_first_name per_people_f.first_name%TYPE;

509: l_country per_addresses.country%TYPE;
510:
511: -- Person details
512: l_last_name per_people_f.last_name%TYPE;
513: l_first_name per_people_f.first_name%TYPE;
514: l_middle_name per_people_f.middle_names%TYPE;
515: l_national_identifier per_people_f.national_identifier%TYPE;
516: l_title per_people_f.title%TYPE;
517: l_date_of_birth per_people_f.date_of_birth%TYPE;

Line 514: l_middle_name per_people_f.middle_names%TYPE;

510:
511: -- Person details
512: l_last_name per_people_f.last_name%TYPE;
513: l_first_name per_people_f.first_name%TYPE;
514: l_middle_name per_people_f.middle_names%TYPE;
515: l_national_identifier per_people_f.national_identifier%TYPE;
516: l_title per_people_f.title%TYPE;
517: l_date_of_birth per_people_f.date_of_birth%TYPE;
518: l_sex per_people_f.sex%TYPE;

Line 515: l_national_identifier per_people_f.national_identifier%TYPE;

511: -- Person details
512: l_last_name per_people_f.last_name%TYPE;
513: l_first_name per_people_f.first_name%TYPE;
514: l_middle_name per_people_f.middle_names%TYPE;
515: l_national_identifier per_people_f.national_identifier%TYPE;
516: l_title per_people_f.title%TYPE;
517: l_date_of_birth per_people_f.date_of_birth%TYPE;
518: l_sex per_people_f.sex%TYPE;
519: l_passport_no varchar2(50);

Line 516: l_title per_people_f.title%TYPE;

512: l_last_name per_people_f.last_name%TYPE;
513: l_first_name per_people_f.first_name%TYPE;
514: l_middle_name per_people_f.middle_names%TYPE;
515: l_national_identifier per_people_f.national_identifier%TYPE;
516: l_title per_people_f.title%TYPE;
517: l_date_of_birth per_people_f.date_of_birth%TYPE;
518: l_sex per_people_f.sex%TYPE;
519: l_passport_no varchar2(50);
520:

Line 517: l_date_of_birth per_people_f.date_of_birth%TYPE;

513: l_first_name per_people_f.first_name%TYPE;
514: l_middle_name per_people_f.middle_names%TYPE;
515: l_national_identifier per_people_f.national_identifier%TYPE;
516: l_title per_people_f.title%TYPE;
517: l_date_of_birth per_people_f.date_of_birth%TYPE;
518: l_sex per_people_f.sex%TYPE;
519: l_passport_no varchar2(50);
520:
521: -- Partner Person Details

Line 518: l_sex per_people_f.sex%TYPE;

514: l_middle_name per_people_f.middle_names%TYPE;
515: l_national_identifier per_people_f.national_identifier%TYPE;
516: l_title per_people_f.title%TYPE;
517: l_date_of_birth per_people_f.date_of_birth%TYPE;
518: l_sex per_people_f.sex%TYPE;
519: l_passport_no varchar2(50);
520:
521: -- Partner Person Details
522: l_partner_last_name per_people_f.last_name%TYPE;

Line 522: l_partner_last_name per_people_f.last_name%TYPE;

518: l_sex per_people_f.sex%TYPE;
519: l_passport_no varchar2(50);
520:
521: -- Partner Person Details
522: l_partner_last_name per_people_f.last_name%TYPE;
523: l_partner_first_name per_people_f.first_name%TYPE;
524: l_partner_middle_name per_people_f.middle_names%TYPE;
525: l_partner_national_id per_people_f.national_identifier%TYPE;
526:

Line 523: l_partner_first_name per_people_f.first_name%TYPE;

519: l_passport_no varchar2(50);
520:
521: -- Partner Person Details
522: l_partner_last_name per_people_f.last_name%TYPE;
523: l_partner_first_name per_people_f.first_name%TYPE;
524: l_partner_middle_name per_people_f.middle_names%TYPE;
525: l_partner_national_id per_people_f.national_identifier%TYPE;
526:
527: -- Assignment Details required for validations

Line 524: l_partner_middle_name per_people_f.middle_names%TYPE;

520:
521: -- Partner Person Details
522: l_partner_last_name per_people_f.last_name%TYPE;
523: l_partner_first_name per_people_f.first_name%TYPE;
524: l_partner_middle_name per_people_f.middle_names%TYPE;
525: l_partner_national_id per_people_f.national_identifier%TYPE;
526:
527: -- Assignment Details required for validations
528: l_aspp number;

Line 525: l_partner_national_id per_people_f.national_identifier%TYPE;

521: -- Partner Person Details
522: l_partner_last_name per_people_f.last_name%TYPE;
523: l_partner_first_name per_people_f.first_name%TYPE;
524: l_partner_middle_name per_people_f.middle_names%TYPE;
525: l_partner_national_id per_people_f.national_identifier%TYPE;
526:
527: -- Assignment Details required for validations
528: l_aspp number;
529: l_start_date date;