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 PAY_GB_EOY_ARCHIVE

Line 780: AND pay_gb_eoy_archive.get_agg_active_start (paaf.assignment_id, c_tax_reference,c_pay_run_date)

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)
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 */

Line 781: = pay_gb_eoy_archive.get_agg_active_start(c_assignment_id, c_tax_reference,c_pay_run_date)

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)
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

Line 782: AND pay_gb_eoy_archive.get_agg_active_end(paaf.assignment_id, c_tax_reference,c_pay_run_date)

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)
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

Line 783: = pay_gb_eoy_archive.get_agg_active_end(c_assignment_id, c_tax_reference,c_pay_run_date)

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)
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