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.

[Home] [Help]

APPS.PAY_GB_RTI_EAS dependencies on PER_PEOPLE_F

Line 26: to use per_all_people_f instead of per_people_f

22: 19-Dec-2012 sampmand 115.7 15989066 Modified to include validation for effective date.
23: 26-Dec-2012 sampmand 115.8 15989066 Modified to remove display of end date for active assignments
24: in warnings section.
25: 09-Jan-2013 sampmand 115.13 15989066 Modified the range cursor to
26: to use per_all_people_f instead of per_people_f
27: 22-Mar-2013 rajganga 115.14 16469408 Modified for address fetching and validations.
28: 25-Mar-2013 rajganga 115.14 16469408 Modified for address fetching and validations.
29: ==========================================================================*/
30:

Line 1320: l_last_name per_people_f.last_name%TYPE;

1316: l_country per_addresses.country%TYPE; --R
1317:
1318:
1319: --person details
1320: l_last_name per_people_f.last_name%TYPE;
1321: l_first_name per_people_f.first_name%TYPE;
1322: l_middle_name per_people_f.middle_names%TYPE;
1323: l_national_identifier per_people_f.national_identifier%TYPE;
1324: l_title per_people_f.title%TYPE;

Line 1321: l_first_name per_people_f.first_name%TYPE;

1317:
1318:
1319: --person details
1320: l_last_name per_people_f.last_name%TYPE;
1321: l_first_name per_people_f.first_name%TYPE;
1322: l_middle_name per_people_f.middle_names%TYPE;
1323: l_national_identifier per_people_f.national_identifier%TYPE;
1324: l_title per_people_f.title%TYPE;
1325: l_date_of_birth per_people_f.date_of_birth%TYPE;

Line 1322: l_middle_name per_people_f.middle_names%TYPE;

1318:
1319: --person details
1320: l_last_name per_people_f.last_name%TYPE;
1321: l_first_name per_people_f.first_name%TYPE;
1322: l_middle_name per_people_f.middle_names%TYPE;
1323: l_national_identifier per_people_f.national_identifier%TYPE;
1324: l_title per_people_f.title%TYPE;
1325: l_date_of_birth per_people_f.date_of_birth%TYPE;
1326: l_sex per_people_f.sex%TYPE;

Line 1323: l_national_identifier per_people_f.national_identifier%TYPE;

1319: --person details
1320: l_last_name per_people_f.last_name%TYPE;
1321: l_first_name per_people_f.first_name%TYPE;
1322: l_middle_name per_people_f.middle_names%TYPE;
1323: l_national_identifier per_people_f.national_identifier%TYPE;
1324: l_title per_people_f.title%TYPE;
1325: l_date_of_birth per_people_f.date_of_birth%TYPE;
1326: l_sex per_people_f.sex%TYPE;
1327:

Line 1324: l_title per_people_f.title%TYPE;

1320: l_last_name per_people_f.last_name%TYPE;
1321: l_first_name per_people_f.first_name%TYPE;
1322: l_middle_name per_people_f.middle_names%TYPE;
1323: l_national_identifier per_people_f.national_identifier%TYPE;
1324: l_title per_people_f.title%TYPE;
1325: l_date_of_birth per_people_f.date_of_birth%TYPE;
1326: l_sex per_people_f.sex%TYPE;
1327:
1328:

Line 1325: l_date_of_birth per_people_f.date_of_birth%TYPE;

1321: l_first_name per_people_f.first_name%TYPE;
1322: l_middle_name per_people_f.middle_names%TYPE;
1323: l_national_identifier per_people_f.national_identifier%TYPE;
1324: l_title per_people_f.title%TYPE;
1325: l_date_of_birth per_people_f.date_of_birth%TYPE;
1326: l_sex per_people_f.sex%TYPE;
1327:
1328:
1329: l_count_char_errors number;

Line 1326: l_sex per_people_f.sex%TYPE;

1322: l_middle_name per_people_f.middle_names%TYPE;
1323: l_national_identifier per_people_f.national_identifier%TYPE;
1324: l_title per_people_f.title%TYPE;
1325: l_date_of_birth per_people_f.date_of_birth%TYPE;
1326: l_sex per_people_f.sex%TYPE;
1327:
1328:
1329: l_count_char_errors number;
1330: l_count_missing_val number;

Line 1558: l_last_name per_people_f.last_name%TYPE;

1554: l_country per_addresses.country%TYPE; --R
1555:
1556:
1557: --person details
1558: l_last_name per_people_f.last_name%TYPE;
1559: l_first_name per_people_f.first_name%TYPE;
1560: l_middle_name per_people_f.middle_names%TYPE;
1561: l_national_identifier per_people_f.national_identifier%TYPE;
1562: l_title per_people_f.title%TYPE;

Line 1559: l_first_name per_people_f.first_name%TYPE;

1555:
1556:
1557: --person details
1558: l_last_name per_people_f.last_name%TYPE;
1559: l_first_name per_people_f.first_name%TYPE;
1560: l_middle_name per_people_f.middle_names%TYPE;
1561: l_national_identifier per_people_f.national_identifier%TYPE;
1562: l_title per_people_f.title%TYPE;
1563: l_date_of_birth per_people_f.date_of_birth%TYPE;

Line 1560: l_middle_name per_people_f.middle_names%TYPE;

1556:
1557: --person details
1558: l_last_name per_people_f.last_name%TYPE;
1559: l_first_name per_people_f.first_name%TYPE;
1560: l_middle_name per_people_f.middle_names%TYPE;
1561: l_national_identifier per_people_f.national_identifier%TYPE;
1562: l_title per_people_f.title%TYPE;
1563: l_date_of_birth per_people_f.date_of_birth%TYPE;
1564: l_sex per_people_f.sex%TYPE;

Line 1561: l_national_identifier per_people_f.national_identifier%TYPE;

1557: --person details
1558: l_last_name per_people_f.last_name%TYPE;
1559: l_first_name per_people_f.first_name%TYPE;
1560: l_middle_name per_people_f.middle_names%TYPE;
1561: l_national_identifier per_people_f.national_identifier%TYPE;
1562: l_title per_people_f.title%TYPE;
1563: l_date_of_birth per_people_f.date_of_birth%TYPE;
1564: l_sex per_people_f.sex%TYPE;
1565:

Line 1562: l_title per_people_f.title%TYPE;

1558: l_last_name per_people_f.last_name%TYPE;
1559: l_first_name per_people_f.first_name%TYPE;
1560: l_middle_name per_people_f.middle_names%TYPE;
1561: l_national_identifier per_people_f.national_identifier%TYPE;
1562: l_title per_people_f.title%TYPE;
1563: l_date_of_birth per_people_f.date_of_birth%TYPE;
1564: l_sex per_people_f.sex%TYPE;
1565:
1566:

Line 1563: l_date_of_birth per_people_f.date_of_birth%TYPE;

1559: l_first_name per_people_f.first_name%TYPE;
1560: l_middle_name per_people_f.middle_names%TYPE;
1561: l_national_identifier per_people_f.national_identifier%TYPE;
1562: l_title per_people_f.title%TYPE;
1563: l_date_of_birth per_people_f.date_of_birth%TYPE;
1564: l_sex per_people_f.sex%TYPE;
1565:
1566:
1567: l_count_char_errors number;

Line 1564: l_sex per_people_f.sex%TYPE;

1560: l_middle_name per_people_f.middle_names%TYPE;
1561: l_national_identifier per_people_f.national_identifier%TYPE;
1562: l_title per_people_f.title%TYPE;
1563: l_date_of_birth per_people_f.date_of_birth%TYPE;
1564: l_sex per_people_f.sex%TYPE;
1565:
1566:
1567: l_count_char_errors number;
1568: l_count_missing_val number;