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.PYUDET dependencies on PAY_GB_EOY_ARCHIVE

Line 571: l_cpe_end_date := pay_gb_eoy_archive.get_agg_active_end(p_assignment_id, p_tax_ref , p_effective_date);

567: elsif p_person_rec.aggregate_flag ='Y' then
568: ------------------------------------------------------------------------------------
569: -- Check if all the asg having same PAYE terminated or ended in future in future --
570: ------------------------------------------------------------------------------------
571: l_cpe_end_date := pay_gb_eoy_archive.get_agg_active_end(p_assignment_id, p_tax_ref , p_effective_date);
572: if l_cpe_end_date <> TO_DATE('31/12/4712', 'DD/MM/RRRR') and l_cpe_end_date >= p_effective_date and
573: (l_future_term_flag = 'Y' or l_future_end_flag = 'Y')then
574: l_return_flag := 'Y';
575: end if;

Line 606: if pay_gb_eoy_archive.get_agg_active_end(l_record.assignment_id, p_paye_ref , p_effective_date)=

602: loop
603: hr_utility.trace(' Active or suspened asg record');
604: hr_utility.trace(' Assignment ID : ' || l_record.assignment_id);
605: hr_utility.trace(' PAYE Ref : ' || p_paye_ref);
606: if pay_gb_eoy_archive.get_agg_active_end(l_record.assignment_id, p_paye_ref , p_effective_date)=
607: pay_gb_eoy_archive.get_agg_active_end(p_assignment_id, p_paye_ref, p_effective_date)
608: AND pay_gb_eoy_archive.get_agg_active_start(l_record.assignment_id, p_paye_ref, p_effective_date)=
609: pay_gb_eoy_archive.get_agg_active_start(p_assignment_id, p_paye_ref, p_effective_date) then
610:

Line 607: pay_gb_eoy_archive.get_agg_active_end(p_assignment_id, p_paye_ref, p_effective_date)

603: hr_utility.trace(' Active or suspened asg record');
604: hr_utility.trace(' Assignment ID : ' || l_record.assignment_id);
605: hr_utility.trace(' PAYE Ref : ' || p_paye_ref);
606: if pay_gb_eoy_archive.get_agg_active_end(l_record.assignment_id, p_paye_ref , p_effective_date)=
607: pay_gb_eoy_archive.get_agg_active_end(p_assignment_id, p_paye_ref, p_effective_date)
608: AND pay_gb_eoy_archive.get_agg_active_start(l_record.assignment_id, p_paye_ref, p_effective_date)=
609: pay_gb_eoy_archive.get_agg_active_start(p_assignment_id, p_paye_ref, p_effective_date) then
610:
611: hr_utility.trace(' Term Asg is in active CPE ');

Line 608: AND pay_gb_eoy_archive.get_agg_active_start(l_record.assignment_id, p_paye_ref, p_effective_date)=

604: hr_utility.trace(' Assignment ID : ' || l_record.assignment_id);
605: hr_utility.trace(' PAYE Ref : ' || p_paye_ref);
606: if pay_gb_eoy_archive.get_agg_active_end(l_record.assignment_id, p_paye_ref , p_effective_date)=
607: pay_gb_eoy_archive.get_agg_active_end(p_assignment_id, p_paye_ref, p_effective_date)
608: AND pay_gb_eoy_archive.get_agg_active_start(l_record.assignment_id, p_paye_ref, p_effective_date)=
609: pay_gb_eoy_archive.get_agg_active_start(p_assignment_id, p_paye_ref, p_effective_date) then
610:
611: hr_utility.trace(' Term Asg is in active CPE ');
612: return 'Y';

Line 609: pay_gb_eoy_archive.get_agg_active_start(p_assignment_id, p_paye_ref, p_effective_date) then

605: hr_utility.trace(' PAYE Ref : ' || p_paye_ref);
606: if pay_gb_eoy_archive.get_agg_active_end(l_record.assignment_id, p_paye_ref , p_effective_date)=
607: pay_gb_eoy_archive.get_agg_active_end(p_assignment_id, p_paye_ref, p_effective_date)
608: AND pay_gb_eoy_archive.get_agg_active_start(l_record.assignment_id, p_paye_ref, p_effective_date)=
609: pay_gb_eoy_archive.get_agg_active_start(p_assignment_id, p_paye_ref, p_effective_date) then
610:
611: hr_utility.trace(' Term Asg is in active CPE ');
612: return 'Y';
613: end if;