APPS.PAY_GB_PAYE_CALC dependencies on PER_ALL_ASSIGNMENTS_F

Line 684: from per_all_assignments_f

680:
681: CURSOR cur_assgt_first_eff_start_date(p_assignment_id number )
682: IS
683: select min(effective_start_date) effective_start_date
684: from per_all_assignments_f
685: where assignment_id = p_assignment_id
686: ;
687:
688: /*12662579 Begin

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

809: pay_element_links_f lnk,
810: pay_element_types_f elt,
811:
812: pay_all_payrolls_f papf,
813: per_all_assignments_f paaf,
814: hr_soft_coding_keyflex hsck
815:
816: where ele.element_entry_id = eev.element_entry_id
817: AND c_pay_run_date between ele.effective_start_date and ele.effective_end_date

Line 838: per_all_assignments_f paaf1

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

Line 850: from per_all_assignments_f paaf2

846: AND pay_p45_pkg.paye_return_p45_issued_flag(c_assignment_id,p_payroll_action_id) = 'N'
847: AND pay_p45_pkg.paye_return_p45_issued_flag(paaf.assignment_id,p_payroll_action_id) = 'N'
848: /*Bug 7389532 - Added the distinct and null condition */
849: AND paaf.period_of_service_id = (select distinct period_of_service_id
850: from per_all_assignments_f paaf2
851: where paaf2.assignment_id=c_assignment_id
852: and paaf.person_id =paaf2.person_id
853: and period_of_service_id is not null)
854:

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

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