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 679: from per_all_people_f papf , per_all_assignments_f paaf

675: ;
676:
677: CURSOR cur_check_aggregated_asg(p_assignment_id number) is
678: select count (distinct nvl(per_information10,'N') ) l_count
679: from per_all_people_f papf , per_all_assignments_f paaf
680: where paaf.assignment_id=p_assignment_id
681: and papf.person_id=paaf.person_id
682: and papf.effective_start_date > l_date_soy
683: and papf.effective_start_date < l_date_eoy ;

Line 776: from per_all_people_f pap,

772: AND papf.payroll_id=paaf.payroll_id
773: AND papf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
774: AND hsck.segment1=c_tax_reference
775: AND paaf.person_id = (select distinct pap.person_id
776: from per_all_people_f pap,
777: per_all_assignments_f paaf1
778: where paaf1.person_id=pap.person_id
779: and paaf1.assignment_id=c_assignment_id)
780: AND pay_gb_eoy_archive.get_agg_active_start (paaf.assignment_id, c_tax_reference,c_pay_run_date)

Line 827: from per_all_people_f

823: fetch cur_get_tax_reference into l_tax_reference_code;
824: close cur_get_tax_reference;
825:
826: select nvl(PER_INFORMATION10,'N') into l_aggregated_asg
827: from per_all_people_f
828: where person_id = (select distinct papf.person_id
829: from per_all_people_f papf, per_all_assignments_f paaf1
830: where papf.person_id=paaf1.person_id
831: AND paaf1.assignment_id= p_assignment_id

Line 829: from per_all_people_f papf, per_all_assignments_f paaf1

825:
826: select nvl(PER_INFORMATION10,'N') into l_aggregated_asg
827: from per_all_people_f
828: where person_id = (select distinct papf.person_id
829: from per_all_people_f papf, per_all_assignments_f paaf1
830: where papf.person_id=paaf1.person_id
831: AND paaf1.assignment_id= p_assignment_id
832: )
833: and l_pay_run_date between effective_start_date and effective_end_date;

Line 931: ,per_all_people_f PEOPLE

927:
928: cursor csr_date_of_death is
929: select PEOPLE.DATE_OF_DEATH
930: from per_all_assignments_f ASSIGN
931: ,per_all_people_f PEOPLE
932: ,fnd_sessions SES
933: where SES.effective_date BETWEEN ASSIGN.effective_start_date
934: AND ASSIGN.effective_end_date
935: and SES.effective_date BETWEEN PEOPLE.effective_start_date