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

Line 89: to use per_all_people_f instead of per_people_f

85: 29-Nov-2012 rajganga 115.64 15914459 Fixed Rti sent for other asgs of PAYE Agg.
86: 03-Jan-2013 ssarap 115.65 15959015 Employees not pickup up. Modified the cursor to
87: fix the issue.
88: 09-Jan-2013 achandwa 115.66 15989627 Employees not pickup up. Modified the range cursor to
89: to use per_all_people_f instead of per_people_f
90: 10-Jan-2013 achandwa 115.70 Modified date_of_leaving validation.
91: 28-Jan-2013 ssarap 115.71 16221548 Changed the csr_asg cursor.
92: 08-Mar-2013 ssarap 115.72 16456256 Added Date track check to sql statement in procedure person_addr_validations_nino
93: 25-Mar-2013 ssarap 115.74 16536044 Modified csr_asg

Line 874: l_last_name per_people_f.last_name%TYPE;

870: l_country per_addresses.country%TYPE; --R
871:
872:
873: --person details
874: l_last_name per_people_f.last_name%TYPE;
875: l_first_name per_people_f.first_name%TYPE;
876: l_middle_name per_people_f.middle_names%TYPE;
877: l_national_identifier per_people_f.national_identifier%TYPE;
878: l_title per_people_f.title%TYPE;

Line 875: l_first_name per_people_f.first_name%TYPE;

871:
872:
873: --person details
874: l_last_name per_people_f.last_name%TYPE;
875: l_first_name per_people_f.first_name%TYPE;
876: l_middle_name per_people_f.middle_names%TYPE;
877: l_national_identifier per_people_f.national_identifier%TYPE;
878: l_title per_people_f.title%TYPE;
879: l_date_of_birth per_people_f.date_of_birth%TYPE;

Line 876: l_middle_name per_people_f.middle_names%TYPE;

872:
873: --person details
874: l_last_name per_people_f.last_name%TYPE;
875: l_first_name per_people_f.first_name%TYPE;
876: l_middle_name per_people_f.middle_names%TYPE;
877: l_national_identifier per_people_f.national_identifier%TYPE;
878: l_title per_people_f.title%TYPE;
879: l_date_of_birth per_people_f.date_of_birth%TYPE;
880: l_sex per_people_f.sex%TYPE;

Line 877: l_national_identifier per_people_f.national_identifier%TYPE;

873: --person details
874: l_last_name per_people_f.last_name%TYPE;
875: l_first_name per_people_f.first_name%TYPE;
876: l_middle_name per_people_f.middle_names%TYPE;
877: l_national_identifier per_people_f.national_identifier%TYPE;
878: l_title per_people_f.title%TYPE;
879: l_date_of_birth per_people_f.date_of_birth%TYPE;
880: l_sex per_people_f.sex%TYPE;
881:

Line 878: l_title per_people_f.title%TYPE;

874: l_last_name per_people_f.last_name%TYPE;
875: l_first_name per_people_f.first_name%TYPE;
876: l_middle_name per_people_f.middle_names%TYPE;
877: l_national_identifier per_people_f.national_identifier%TYPE;
878: l_title per_people_f.title%TYPE;
879: l_date_of_birth per_people_f.date_of_birth%TYPE;
880: l_sex per_people_f.sex%TYPE;
881:
882:

Line 879: l_date_of_birth per_people_f.date_of_birth%TYPE;

875: l_first_name per_people_f.first_name%TYPE;
876: l_middle_name per_people_f.middle_names%TYPE;
877: l_national_identifier per_people_f.national_identifier%TYPE;
878: l_title per_people_f.title%TYPE;
879: l_date_of_birth per_people_f.date_of_birth%TYPE;
880: l_sex per_people_f.sex%TYPE;
881:
882:
883: l_count_char_errors number;

Line 880: l_sex per_people_f.sex%TYPE;

876: l_middle_name per_people_f.middle_names%TYPE;
877: l_national_identifier per_people_f.national_identifier%TYPE;
878: l_title per_people_f.title%TYPE;
879: l_date_of_birth per_people_f.date_of_birth%TYPE;
880: l_sex per_people_f.sex%TYPE;
881:
882:
883: l_count_char_errors number;
884: l_count_missing_val number;

Line 1089: l_last_name per_people_f.last_name%TYPE;

1085: l_country per_addresses.country%TYPE; --R
1086:
1087:
1088: --person details
1089: l_last_name per_people_f.last_name%TYPE;
1090: l_first_name per_people_f.first_name%TYPE;
1091: l_middle_name per_people_f.middle_names%TYPE;
1092: l_national_identifier per_people_f.national_identifier%TYPE;
1093: l_title per_people_f.title%TYPE;

Line 1090: l_first_name per_people_f.first_name%TYPE;

1086:
1087:
1088: --person details
1089: l_last_name per_people_f.last_name%TYPE;
1090: l_first_name per_people_f.first_name%TYPE;
1091: l_middle_name per_people_f.middle_names%TYPE;
1092: l_national_identifier per_people_f.national_identifier%TYPE;
1093: l_title per_people_f.title%TYPE;
1094: l_date_of_birth per_people_f.date_of_birth%TYPE;

Line 1091: l_middle_name per_people_f.middle_names%TYPE;

1087:
1088: --person details
1089: l_last_name per_people_f.last_name%TYPE;
1090: l_first_name per_people_f.first_name%TYPE;
1091: l_middle_name per_people_f.middle_names%TYPE;
1092: l_national_identifier per_people_f.national_identifier%TYPE;
1093: l_title per_people_f.title%TYPE;
1094: l_date_of_birth per_people_f.date_of_birth%TYPE;
1095: l_sex per_people_f.sex%TYPE;

Line 1092: l_national_identifier per_people_f.national_identifier%TYPE;

1088: --person details
1089: l_last_name per_people_f.last_name%TYPE;
1090: l_first_name per_people_f.first_name%TYPE;
1091: l_middle_name per_people_f.middle_names%TYPE;
1092: l_national_identifier per_people_f.national_identifier%TYPE;
1093: l_title per_people_f.title%TYPE;
1094: l_date_of_birth per_people_f.date_of_birth%TYPE;
1095: l_sex per_people_f.sex%TYPE;
1096:

Line 1093: l_title per_people_f.title%TYPE;

1089: l_last_name per_people_f.last_name%TYPE;
1090: l_first_name per_people_f.first_name%TYPE;
1091: l_middle_name per_people_f.middle_names%TYPE;
1092: l_national_identifier per_people_f.national_identifier%TYPE;
1093: l_title per_people_f.title%TYPE;
1094: l_date_of_birth per_people_f.date_of_birth%TYPE;
1095: l_sex per_people_f.sex%TYPE;
1096:
1097:

Line 1094: l_date_of_birth per_people_f.date_of_birth%TYPE;

1090: l_first_name per_people_f.first_name%TYPE;
1091: l_middle_name per_people_f.middle_names%TYPE;
1092: l_national_identifier per_people_f.national_identifier%TYPE;
1093: l_title per_people_f.title%TYPE;
1094: l_date_of_birth per_people_f.date_of_birth%TYPE;
1095: l_sex per_people_f.sex%TYPE;
1096:
1097:
1098: l_count_char_errors number;

Line 1095: l_sex per_people_f.sex%TYPE;

1091: l_middle_name per_people_f.middle_names%TYPE;
1092: l_national_identifier per_people_f.national_identifier%TYPE;
1093: l_title per_people_f.title%TYPE;
1094: l_date_of_birth per_people_f.date_of_birth%TYPE;
1095: l_sex per_people_f.sex%TYPE;
1096:
1097:
1098: l_count_char_errors number;
1099: l_count_missing_val number;