APPS.PAY_GB_AEI_API dependencies on PER_ALL_PEOPLE_F

Line 244: from per_all_people_f

240:
241: cursor csr_aggr_paye_flag (c_person_id in number,
242: c_effective_date in date) is
243: select per_information10
244: from per_all_people_f
245: where person_id = c_person_id
246: and c_effective_date between
247: effective_start_date and effective_end_date;
248:

Line 250: l_aggregated_paye_flag per_all_people_f.per_information10%type;

246: and c_effective_date between
247: effective_start_date and effective_end_date;
248:
249: l_effective_date date;
250: l_aggregated_paye_flag per_all_people_f.per_information10%type;
251: l_period_of_service_id per_all_assignments_f.period_of_service_id%type;
252: l_object_version_number number;
253: l_assignment_extra_info_id number;
254: --

Line 328: from per_all_people_f

324: -- to fetch the earliest aggregation start date near to the manual issue date/override date.
325: --
326: cursor csr_latest_aggr_start_date(c_person_id number, c_effective_date date) is
327: select max(effective_end_date) + 1
328: from per_all_people_f
329: where person_id = c_person_id
330: and nvl(per_information10,'N') = 'N'
331: and effective_end_date < c_effective_date;
332:

Line 697: from per_all_people_f

693:
694: cursor csr_aggr_paye_flag (c_person_id in number,
695: c_effective_date in date) is
696: select per_information10
697: from per_all_people_f
698: where person_id = c_person_id
699: and c_effective_date between
700: effective_start_date and effective_end_date;
701:

Line 703: l_aggregated_paye_flag per_all_people_f.per_information10%type;

699: and c_effective_date between
700: effective_start_date and effective_end_date;
701:
702: l_effective_date date;
703: l_aggregated_paye_flag per_all_people_f.per_information10%type;
704: l_period_of_service_id number;
705:
706:
707: l_old_aei_information3 per_assignment_extra_info.aei_information3%type;

Line 710: l_old_aggregated_paye_flag per_all_people_f.per_information10%type;

706:
707: l_old_aei_information3 per_assignment_extra_info.aei_information3%type;
708: l_old_aei_information4 per_assignment_extra_info.aei_information4%type;
709: l_old_effective_date date;
710: l_old_aggregated_paye_flag per_all_people_f.per_information10%type;
711: l_old_asg_tax_dist varchar2(50);
712: l_old_period_of_service_id number;
713: l_information_type per_assignment_extra_info.information_type%type;
714: l_assignment_extra_info_id number;

Line 799: from per_all_people_f

795: -- to fetch the earliest aggregation start date near to the manual issue date/override date.
796: --
797: cursor csr_latest_aggr_start_date(c_person_id number, c_effective_date date) is
798: select max(effective_end_date) + 1
799: from per_all_people_f
800: where person_id = c_person_id
801: and nvl(per_information10,'N') = 'N'
802: and effective_end_date < c_effective_date;
803:

Line 1404: from per_all_people_f

1400: --
1401: cursor csr_aggr_paye_flag (c_person_id in number,
1402: c_effective_date in date) is
1403: select per_information10
1404: from per_all_people_f
1405: where person_id = c_person_id
1406: and c_effective_date between
1407: effective_start_date and effective_end_date;
1408: --

Line 1411: l_aggregated_paye_flag per_all_people_f.per_information10%type;

1407: effective_start_date and effective_end_date;
1408: --
1409:
1410: l_effective_date date;
1411: l_aggregated_paye_flag per_all_people_f.per_information10%type;
1412: l_period_of_service_id per_all_assignments_f.period_of_service_id%type;
1413: l_assignment_id per_all_assignments_f.assignment_id%type;
1414: l_object_version_number number;
1415:

Line 1501: from per_all_people_f

1497: -- to fetch the earliest aggregation start date near to the manual issue date/override date.
1498: --
1499: cursor csr_latest_aggr_start_date(c_person_id number, c_effective_date date) is
1500: select max(effective_end_date) + 1
1501: from per_all_people_f
1502: where person_id = c_person_id
1503: and nvl(per_information10,'N') = 'N'
1504: and effective_end_date < c_effective_date;
1505: