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.8.12020000.3 2013/02/07 11:56:51 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_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

Line 92: l_nationality_person per_all_people_f.nationality%type;

88: (p_assignment_id IN per_all_assignments_f.assignment_id%type,
89: p_date_earned IN Date) return varchar2
90: is
91: l_nationality hr_lookups.meaning%type;
92: l_nationality_person per_all_people_f.nationality%type;
93: begin
94:
95: -- hr_utility.trace_on(null,'bpk1');
96: -- hr_utility.set_location('Entering: ' , 10);

Line 107: From PER_ALL_PEOPLE_F

103: hr_utility.set_location('l_person_id: '||l_person_id , 10);
104:
105: Select PER_INFORMATION18
106: Into l_nationality_person
107: From PER_ALL_PEOPLE_F
108: Where PERSON_ID = l_person_id
109: AND p_date_earned between EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
110:
111: hr_utility.set_location('l_nationality_person: '||l_nationality_person , 10);