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

Line 740: from per_all_people_f papf , per_all_assignments_f paaf

736: --12662579 end
737:
738: CURSOR cur_check_aggregated_asg(p_assignment_id number) is
739: select count (distinct nvl(per_information10,'N') ) l_count
740: from per_all_people_f papf , per_all_assignments_f paaf
741: where paaf.assignment_id=p_assignment_id
742: and papf.person_id=paaf.person_id
743: and papf.effective_start_date > l_date_soy
744: and papf.effective_start_date < l_date_eoy ;

Line 837: from per_all_people_f pap,

833: AND papf.payroll_id=paaf.payroll_id
834: AND papf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
835: AND hsck.segment1=c_tax_reference
836: AND paaf.person_id = (select distinct pap.person_id
837: from per_all_people_f pap,
838: per_all_assignments_f paaf1
839: where paaf1.person_id=pap.person_id
840: and paaf1.assignment_id=c_assignment_id)
841: AND pay_gb_eoy_archive.get_agg_active_start (paaf.assignment_id, c_tax_reference,c_pay_run_date)

Line 864: from per_all_people_f

860: -- Bug#9278271
861: CURSOR cur_get_paye_agg(p_assignment_id number,
862: p_pay_run_date date) IS
863: select nvl(PER_INFORMATION10,'N')
864: from per_all_people_f
865: where person_id = (select distinct papf.person_id
866: from per_all_people_f papf, per_all_assignments_f paaf1
867: where papf.person_id=paaf1.person_id
868: and paaf1.assignment_id= p_assignment_id)

Line 866: from per_all_people_f papf, per_all_assignments_f paaf1

862: p_pay_run_date date) IS
863: select nvl(PER_INFORMATION10,'N')
864: from per_all_people_f
865: where person_id = (select distinct papf.person_id
866: from per_all_people_f papf, per_all_assignments_f paaf1
867: where papf.person_id=paaf1.person_id
868: and paaf1.assignment_id= p_assignment_id)
869: and p_pay_run_date between effective_start_date and effective_end_date;
870:

Line 904: from per_all_people_f

900: close cur_get_tax_reference;
901:
902: -- Start of bug#9278271
903: /* select nvl(PER_INFORMATION10,'N') into l_aggregated_asg
904: from per_all_people_f
905: where person_id = (select distinct papf.person_id
906: from per_all_people_f papf, per_all_assignments_f paaf1
907: where papf.person_id=paaf1.person_id
908: AND paaf1.assignment_id= p_assignment_id

Line 906: from per_all_people_f papf, per_all_assignments_f paaf1

902: -- Start of bug#9278271
903: /* select nvl(PER_INFORMATION10,'N') into l_aggregated_asg
904: from per_all_people_f
905: where person_id = (select distinct papf.person_id
906: from per_all_people_f papf, per_all_assignments_f paaf1
907: where papf.person_id=paaf1.person_id
908: AND paaf1.assignment_id= p_assignment_id
909: )
910: and l_pay_run_date between effective_start_date and effective_end_date;*/

Line 1082: ,per_all_people_f PEOPLE

1078:
1079: cursor csr_date_of_death is
1080: select PEOPLE.DATE_OF_DEATH
1081: from per_all_assignments_f ASSIGN
1082: ,per_all_people_f PEOPLE
1083: ,fnd_sessions SES
1084: where SES.effective_date BETWEEN ASSIGN.effective_start_date
1085: AND ASSIGN.effective_end_date
1086: and SES.effective_date BETWEEN PEOPLE.effective_start_date