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_EYU dependencies on PER_PEOPLE_F

Line 2660: l_last_name per_people_f.last_name%TYPE;

2656: l_postal_code per_addresses.postal_code%TYPE;
2657: l_country per_addresses.country%TYPE;
2658:
2659: -- Person details
2660: l_last_name per_people_f.last_name%TYPE;
2661: l_first_name per_people_f.first_name%TYPE;
2662: l_middle_name per_people_f.middle_names%TYPE;
2663: l_national_identifier per_people_f.national_identifier%TYPE;
2664: l_title per_people_f.title%TYPE;

Line 2661: l_first_name per_people_f.first_name%TYPE;

2657: l_country per_addresses.country%TYPE;
2658:
2659: -- Person details
2660: l_last_name per_people_f.last_name%TYPE;
2661: l_first_name per_people_f.first_name%TYPE;
2662: l_middle_name per_people_f.middle_names%TYPE;
2663: l_national_identifier per_people_f.national_identifier%TYPE;
2664: l_title per_people_f.title%TYPE;
2665: l_date_of_birth per_people_f.date_of_birth%TYPE;

Line 2662: l_middle_name per_people_f.middle_names%TYPE;

2658:
2659: -- Person details
2660: l_last_name per_people_f.last_name%TYPE;
2661: l_first_name per_people_f.first_name%TYPE;
2662: l_middle_name per_people_f.middle_names%TYPE;
2663: l_national_identifier per_people_f.national_identifier%TYPE;
2664: l_title per_people_f.title%TYPE;
2665: l_date_of_birth per_people_f.date_of_birth%TYPE;
2666: l_sex per_people_f.sex%TYPE;

Line 2663: l_national_identifier per_people_f.national_identifier%TYPE;

2659: -- Person details
2660: l_last_name per_people_f.last_name%TYPE;
2661: l_first_name per_people_f.first_name%TYPE;
2662: l_middle_name per_people_f.middle_names%TYPE;
2663: l_national_identifier per_people_f.national_identifier%TYPE;
2664: l_title per_people_f.title%TYPE;
2665: l_date_of_birth per_people_f.date_of_birth%TYPE;
2666: l_sex per_people_f.sex%TYPE;
2667: l_passport_no varchar2(50);

Line 2664: l_title per_people_f.title%TYPE;

2660: l_last_name per_people_f.last_name%TYPE;
2661: l_first_name per_people_f.first_name%TYPE;
2662: l_middle_name per_people_f.middle_names%TYPE;
2663: l_national_identifier per_people_f.national_identifier%TYPE;
2664: l_title per_people_f.title%TYPE;
2665: l_date_of_birth per_people_f.date_of_birth%TYPE;
2666: l_sex per_people_f.sex%TYPE;
2667: l_passport_no varchar2(50);
2668:

Line 2665: l_date_of_birth per_people_f.date_of_birth%TYPE;

2661: l_first_name per_people_f.first_name%TYPE;
2662: l_middle_name per_people_f.middle_names%TYPE;
2663: l_national_identifier per_people_f.national_identifier%TYPE;
2664: l_title per_people_f.title%TYPE;
2665: l_date_of_birth per_people_f.date_of_birth%TYPE;
2666: l_sex per_people_f.sex%TYPE;
2667: l_passport_no varchar2(50);
2668:
2669: -- Partner Person Details

Line 2666: l_sex per_people_f.sex%TYPE;

2662: l_middle_name per_people_f.middle_names%TYPE;
2663: l_national_identifier per_people_f.national_identifier%TYPE;
2664: l_title per_people_f.title%TYPE;
2665: l_date_of_birth per_people_f.date_of_birth%TYPE;
2666: l_sex per_people_f.sex%TYPE;
2667: l_passport_no varchar2(50);
2668:
2669: -- Partner Person Details
2670: l_partner_last_name per_people_f.last_name%TYPE;

Line 2670: l_partner_last_name per_people_f.last_name%TYPE;

2666: l_sex per_people_f.sex%TYPE;
2667: l_passport_no varchar2(50);
2668:
2669: -- Partner Person Details
2670: l_partner_last_name per_people_f.last_name%TYPE;
2671: l_partner_first_name per_people_f.first_name%TYPE;
2672: l_partner_middle_name per_people_f.middle_names%TYPE;
2673: l_partner_national_id per_people_f.national_identifier%TYPE;
2674:

Line 2671: l_partner_first_name per_people_f.first_name%TYPE;

2667: l_passport_no varchar2(50);
2668:
2669: -- Partner Person Details
2670: l_partner_last_name per_people_f.last_name%TYPE;
2671: l_partner_first_name per_people_f.first_name%TYPE;
2672: l_partner_middle_name per_people_f.middle_names%TYPE;
2673: l_partner_national_id per_people_f.national_identifier%TYPE;
2674:
2675: -- Assignment Details required for validations

Line 2672: l_partner_middle_name per_people_f.middle_names%TYPE;

2668:
2669: -- Partner Person Details
2670: l_partner_last_name per_people_f.last_name%TYPE;
2671: l_partner_first_name per_people_f.first_name%TYPE;
2672: l_partner_middle_name per_people_f.middle_names%TYPE;
2673: l_partner_national_id per_people_f.national_identifier%TYPE;
2674:
2675: -- Assignment Details required for validations
2676: l_aspp NUMBER;

Line 2673: l_partner_national_id per_people_f.national_identifier%TYPE;

2669: -- Partner Person Details
2670: l_partner_last_name per_people_f.last_name%TYPE;
2671: l_partner_first_name per_people_f.first_name%TYPE;
2672: l_partner_middle_name per_people_f.middle_names%TYPE;
2673: l_partner_national_id per_people_f.national_identifier%TYPE;
2674:
2675: -- Assignment Details required for validations
2676: l_aspp NUMBER;
2677: l_start_date DATE;