APPS.PAY_GB_PAYE_CALC dependencies on PER_ALL_ASSIGNMENTS_F

Line 638: from per_all_assignments_f

634:
635: CURSOR cur_assgt_first_eff_start_date(p_assignment_id number )
636: IS
637: select min(effective_start_date) effective_start_date
638: from per_all_assignments_f
639: where assignment_id = p_assignment_id
640: ;
641:
642: CURSOR cur_chk_pay_actions( p_payroll_action_id number, p_assignment_id number )

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 752: per_all_assignments_f paaf,

748: pay_element_links_f lnk,
749: pay_element_types_f elt,
750:
751: pay_all_payrolls_f papf,
752: per_all_assignments_f paaf,
753: hr_soft_coding_keyflex hsck
754:
755: where ele.element_entry_id = eev.element_entry_id
756: AND c_pay_run_date between ele.effective_start_date and ele.effective_end_date

Line 777: per_all_assignments_f paaf1

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)
781: = pay_gb_eoy_archive.get_agg_active_start(c_assignment_id, c_tax_reference,c_pay_run_date)

Line 786: from per_all_assignments_f paaf2

782: AND pay_gb_eoy_archive.get_agg_active_end(paaf.assignment_id, c_tax_reference,c_pay_run_date)
783: = pay_gb_eoy_archive.get_agg_active_end(c_assignment_id, c_tax_reference,c_pay_run_date)
784: /*Bug 7389532 - Added the distinct and null condition */
785: AND paaf.period_of_service_id = (select distinct period_of_service_id
786: from per_all_assignments_f paaf2
787: where paaf2.assignment_id=c_assignment_id
788: and paaf.person_id =paaf2.person_id
789: and period_of_service_id is not null)
790:

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 930: from per_all_assignments_f ASSIGN

926:
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