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

Line 12: FROM per_all_people_f PAPF

8:
9: CURSOR GET_PERSON_DETAILS IS
10: SELECT papf.person_id, PAPF.object_version_number, PAPF.employee_number,
11: PER_INFORMATION9,PER_INFORMATION10 ,CURRENT_EMPLOYEE_FLAG
12: FROM per_all_people_f PAPF
13: WHERE papf.person_id = p_person_id
14: AND p_effective_date BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.effective_end_date;
15:
16: L_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE;

Line 16: L_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE;

12: FROM per_all_people_f PAPF
13: WHERE papf.person_id = p_person_id
14: AND p_effective_date BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.effective_end_date;
15:
16: L_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE;
17: l_validate Boolean;
18: l_object_version_number NUMBER;
19: l_employee_number PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE;
20: l_paye_aggregate_assignment PER_ALL_PEOPLE_F.PER_INFORMATION10%type;

Line 19: l_employee_number PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE;

15:
16: L_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE;
17: l_validate Boolean;
18: l_object_version_number NUMBER;
19: l_employee_number PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE;
20: l_paye_aggregate_assignment PER_ALL_PEOPLE_F.PER_INFORMATION10%type;
21: l_ni_aggregate_assignment PER_ALL_PEOPLE_F.PER_INFORMATION10%type;
22: l_full_name PER_ALL_PEOPLE_F.full_name%TYPE;
23: l_comment_id number;

Line 20: l_paye_aggregate_assignment PER_ALL_PEOPLE_F.PER_INFORMATION10%type;

16: L_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE;
17: l_validate Boolean;
18: l_object_version_number NUMBER;
19: l_employee_number PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE;
20: l_paye_aggregate_assignment PER_ALL_PEOPLE_F.PER_INFORMATION10%type;
21: l_ni_aggregate_assignment PER_ALL_PEOPLE_F.PER_INFORMATION10%type;
22: l_full_name PER_ALL_PEOPLE_F.full_name%TYPE;
23: l_comment_id number;
24: l_name_combination_warning boolean;

Line 21: l_ni_aggregate_assignment PER_ALL_PEOPLE_F.PER_INFORMATION10%type;

17: l_validate Boolean;
18: l_object_version_number NUMBER;
19: l_employee_number PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE;
20: l_paye_aggregate_assignment PER_ALL_PEOPLE_F.PER_INFORMATION10%type;
21: l_ni_aggregate_assignment PER_ALL_PEOPLE_F.PER_INFORMATION10%type;
22: l_full_name PER_ALL_PEOPLE_F.full_name%TYPE;
23: l_comment_id number;
24: l_name_combination_warning boolean;
25: l_assign_payroll_warning boolean;

Line 22: l_full_name PER_ALL_PEOPLE_F.full_name%TYPE;

18: l_object_version_number NUMBER;
19: l_employee_number PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE;
20: l_paye_aggregate_assignment PER_ALL_PEOPLE_F.PER_INFORMATION10%type;
21: l_ni_aggregate_assignment PER_ALL_PEOPLE_F.PER_INFORMATION10%type;
22: l_full_name PER_ALL_PEOPLE_F.full_name%TYPE;
23: l_comment_id number;
24: l_name_combination_warning boolean;
25: l_assign_payroll_warning boolean;
26: l_orig_hire_warning boolean;

Line 30: l_CURRENT_EMPLOYEE_FLAG PER_ALL_PEOPLE_F.CURRENT_EMPLOYEE_FLAG%type;

26: l_orig_hire_warning boolean;
27: l_end_date date;
28: l_start_date date;
29: l_profile_value varchar2(30);
30: l_CURRENT_EMPLOYEE_FLAG PER_ALL_PEOPLE_F.CURRENT_EMPLOYEE_FLAG%type;
31:
32: BEGIN
33:
34: fnd_profile.get('GB_PAYE_NI_AGGREGATION',l_profile_value);

Line 189: FROM per_all_people_f PAPF

185:
186: CURSOR GET_PERSON_DETAILS IS
187: SELECT papf.person_id, PAPF.object_version_number, PAPF.employee_number,
188: PER_INFORMATION9, PER_INFORMATION10 ,CURRENT_EMPLOYEE_FLAG
189: FROM per_all_people_f PAPF
190: WHERE papf.person_id = p_person_id
191: AND p_effective_date BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.effective_end_date;
192:
193: L_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE;

Line 193: L_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE;

189: FROM per_all_people_f PAPF
190: WHERE papf.person_id = p_person_id
191: AND p_effective_date BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.effective_end_date;
192:
193: L_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE;
194: l_validate Boolean;
195: l_object_version_number NUMBER;
196: l_employee_number PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE;
197: l_paye_aggregate_assignment PER_ALL_PEOPLE_F.PER_INFORMATION10%type;

Line 196: l_employee_number PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE;

192:
193: L_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE;
194: l_validate Boolean;
195: l_object_version_number NUMBER;
196: l_employee_number PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE;
197: l_paye_aggregate_assignment PER_ALL_PEOPLE_F.PER_INFORMATION10%type;
198: l_ni_aggregate_assignment PER_ALL_PEOPLE_F.PER_INFORMATION10%type;
199: l_full_name PER_ALL_PEOPLE_F.full_name%TYPE;
200: l_comment_id number;

Line 197: l_paye_aggregate_assignment PER_ALL_PEOPLE_F.PER_INFORMATION10%type;

193: L_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE;
194: l_validate Boolean;
195: l_object_version_number NUMBER;
196: l_employee_number PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE;
197: l_paye_aggregate_assignment PER_ALL_PEOPLE_F.PER_INFORMATION10%type;
198: l_ni_aggregate_assignment PER_ALL_PEOPLE_F.PER_INFORMATION10%type;
199: l_full_name PER_ALL_PEOPLE_F.full_name%TYPE;
200: l_comment_id number;
201: l_name_combination_warning boolean;

Line 198: l_ni_aggregate_assignment PER_ALL_PEOPLE_F.PER_INFORMATION10%type;

194: l_validate Boolean;
195: l_object_version_number NUMBER;
196: l_employee_number PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE;
197: l_paye_aggregate_assignment PER_ALL_PEOPLE_F.PER_INFORMATION10%type;
198: l_ni_aggregate_assignment PER_ALL_PEOPLE_F.PER_INFORMATION10%type;
199: l_full_name PER_ALL_PEOPLE_F.full_name%TYPE;
200: l_comment_id number;
201: l_name_combination_warning boolean;
202: l_assign_payroll_warning boolean;

Line 199: l_full_name PER_ALL_PEOPLE_F.full_name%TYPE;

195: l_object_version_number NUMBER;
196: l_employee_number PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE;
197: l_paye_aggregate_assignment PER_ALL_PEOPLE_F.PER_INFORMATION10%type;
198: l_ni_aggregate_assignment PER_ALL_PEOPLE_F.PER_INFORMATION10%type;
199: l_full_name PER_ALL_PEOPLE_F.full_name%TYPE;
200: l_comment_id number;
201: l_name_combination_warning boolean;
202: l_assign_payroll_warning boolean;
203: l_orig_hire_warning boolean;

Line 207: l_CURRENT_EMPLOYEE_FLAG PER_ALL_PEOPLE_F.CURRENT_EMPLOYEE_FLAG%type;

203: l_orig_hire_warning boolean;
204: l_end_date date;
205: l_start_date date;
206: l_profile_value varchar2(30);
207: l_CURRENT_EMPLOYEE_FLAG PER_ALL_PEOPLE_F.CURRENT_EMPLOYEE_FLAG%type;
208:
209: BEGIN
210:
211: fnd_profile.get('GB_PAYE_NI_AGGREGATION',l_profile_value);