APPS.PAY_KW_GENERAL dependencies on PER_ALL_PEOPLE_F

Line 5: l_person_id per_all_people_f.person_id%type;

1: package body pay_kw_general as
2: /* $Header: pykwgenr.pkb 120.2.12010000.2 2008/09/23 12:59:02 bkeshary ship $ */
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_NATIONALITY_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_NATIONALITY_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 65: From PER_ALL_PEOPLE_F

61: END;
62: BEGIN
63: Select Nationality
64: Into l_nationality_person
65: From PER_ALL_PEOPLE_F
66: Where PERSON_ID = l_person_id
67: AND p_date_earned between EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
68: EXCEPTION
69: WHEN no_data_found Then