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.PQP_GB_PSI_BASIC_DATA dependencies on PER_ALL_PEOPLE_F

Line 749: l_age_verification_indicator per_all_people_f.date_employee_data_verified%TYPE;

745: RETURN number IS
746: --
747: l_proc_name VARCHAR2(61):=
748: g_proc_name||'age_verification_indicator';
749: l_age_verification_indicator per_all_people_f.date_employee_data_verified%TYPE;
750: --
751: BEGIN
752:
753: debug_enter(l_proc_name);

Line 808: l_person_decoration per_all_people_f.honors%TYPE;

804: RETURN number IS
805: --
806: l_proc_name VARCHAR2(61):=
807: g_proc_name||'person_decoration';
808: l_person_decoration per_all_people_f.honors%TYPE;
809: -- For Bug 8790100
810: l_ret_person_decoration per_all_people_f.honors%TYPE;
811: --
812: BEGIN

Line 810: l_ret_person_decoration per_all_people_f.honors%TYPE;

806: l_proc_name VARCHAR2(61):=
807: g_proc_name||'person_decoration';
808: l_person_decoration per_all_people_f.honors%TYPE;
809: -- For Bug 8790100
810: l_ret_person_decoration per_all_people_f.honors%TYPE;
811: --
812: BEGIN
813:
814: debug_enter(l_proc_name);

Line 850: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'

846: debug('ben_ext_person.g_chg_pay_column:' || ben_ext_person.g_chg_pay_column, 30);
847: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 30);
848:
849: --
850: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'
851: AND
852: ben_ext_person.g_chg_pay_column = 'HONORS'
853: AND
854: ben_ext_person.g_chg_update_type <> 'I'

Line 963: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'

959: debug('ben_ext_person.g_chg_pay_table:' || ben_ext_person.g_chg_pay_table, 44);
960: debug('ben_ext_person.g_chg_pay_column:' || ben_ext_person.g_chg_pay_column, 44);
961: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 44);
962: --
963: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'
964: AND ben_ext_person.g_chg_pay_column = 'TITLE'
965: AND ben_ext_person.g_chg_update_type <> 'I'
966: THEN
967: l_ret_title := '******';

Line 1297: l_spouse_date_of_birth per_all_people_f.date_of_birth%TYPE;

1293: --
1294:
1295: l_proc_name VARCHAR2(61):=
1296: g_proc_name||'spouse_date_of_birth';
1297: l_spouse_date_of_birth per_all_people_f.date_of_birth%TYPE;
1298: --
1299: BEGIN
1300:
1301: debug_enter(l_proc_name);

Line 1471: l_ret_prevsur per_all_people_f.previous_last_name%type;

1467: g_proc_name||'basic_extract_main';
1468: l_value number;
1469: l_effective_date DATE;
1470: -- For Bug 8790100
1471: l_ret_prevsur per_all_people_f.previous_last_name%type;
1472: l_ret_midname per_all_people_f.middle_names%type;
1473: --
1474: BEGIN
1475:

Line 1472: l_ret_midname per_all_people_f.middle_names%type;

1468: l_value number;
1469: l_effective_date DATE;
1470: -- For Bug 8790100
1471: l_ret_prevsur per_all_people_f.previous_last_name%type;
1472: l_ret_midname per_all_people_f.middle_names%type;
1473: --
1474: BEGIN
1475:
1476: debug_enter(l_proc_name);

Line 1645: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'

1641: debug('ben_ext_person.g_chg_pay_table:' || ben_ext_person.g_chg_pay_table, 30);
1642: debug('ben_ext_person.g_chg_pay_column:' || ben_ext_person.g_chg_pay_column, 30);
1643: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 30);
1644: --
1645: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'
1646: AND ben_ext_person.g_chg_pay_column = 'PREVIOUS_LAST_NAME'
1647: AND ben_ext_person.g_chg_update_type <> 'I'
1648: THEN -- this is checking location_event for case (3) and (4)
1649: l_ret_prevsur := '********************';

Line 1689: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'

1685: debug('ben_ext_person.g_chg_pay_column:' || ben_ext_person.g_chg_pay_column, 30);
1686: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 30);
1687:
1688: --
1689: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'
1690: AND ben_ext_person.g_chg_pay_column = 'MIDDLE_NAMES'
1691: AND ben_ext_person.g_chg_update_type <> 'I'
1692: THEN -- this is checking location_event for case (3) and (4)
1693: l_ret_midname := '********************';