APPS.PAY_AE_GENERAL dependencies on PER_ALL_PEOPLE_F

Line 5: l_person_id per_all_people_f.person_id%type;

1: package body pay_ae_general as
2: /* $Header: pyaegenr.pkb 120.6 2005/11/10 03:05:54 abppradh noship $ */
3: g_package varchar2(30);
4: l_organization_id hr_all_organization_units.organization_id%type;
5: l_person_id per_all_people_f.person_id%type;
6: l_nationality_cd hr_lookups.meaning%type;
7: l_nationality_person per_all_people_f.nationality%type;
8: ------------------------------------------------------------------------
9: -- Function LOCAL_NATNATIONALITY_NOT_DEFINED

Line 7: l_nationality_person per_all_people_f.nationality%type;

3: g_package varchar2(30);
4: l_organization_id hr_all_organization_units.organization_id%type;
5: l_person_id per_all_people_f.person_id%type;
6: l_nationality_cd hr_lookups.meaning%type;
7: l_nationality_person per_all_people_f.nationality%type;
8: ------------------------------------------------------------------------
9: -- Function LOCAL_NATNATIONALITY_NOT_DEFINED
10: -- This function return NOTEXISTS If the value for HR: Local Nationality
11: -- Profile has not been defined else it retuns EXISTS.

Line 57: From PER_ALL_PEOPLE_F

53: END;
54: BEGIN
55: Select per_information18
56: Into l_nationality_person
57: From PER_ALL_PEOPLE_F
58: Where PERSON_ID = l_person_id
59: AND p_date_earned between EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
60: EXCEPTION
61: WHEN no_data_found Then