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

Line 96: pay_gb_eoy_archive.get_agg_active_start(paa.assignment_id, p_tax_district, greatest(paa.effective_start_date,ppf.effective_start_date)) cpe_start_date,

92: nvl(min(decode(inv.name, 'Tax Previous', eev.screen_entry_value, null)),0)||
93: nvl(min(decode(inv.name, 'Authority', substr(HR_GENERAL.DECODE_LOOKUP('GB_AUTHORITY',eev.screen_entry_value),1,80),null)),0)||
94: nvl(ele.entry_information1,0)||
95: nvl(ele.entry_information2,0) VALUE,
96: pay_gb_eoy_archive.get_agg_active_start(paa.assignment_id, p_tax_district, greatest(paa.effective_start_date,ppf.effective_start_date)) cpe_start_date,
97: paa.assignment_id assignment_id,
98: eev.effective_start_date effective_start_date,
99: eev.effective_end_date effective_end_date
100: from

Line 155: and pay_gb_eoy_archive.get_agg_active_end(paa.assignment_id, p_tax_district, greatest(paa.effective_start_date,ppf.effective_start_date))

151: and papf.effective_end_date >= p_start_date
152: and papf.payroll_id = paaf.payroll_id
153: and papf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
154: and hsck.segment1 = scl.segment1
155: and pay_gb_eoy_archive.get_agg_active_end(paa.assignment_id, p_tax_district, greatest(paa.effective_start_date,ppf.effective_start_date))
156: = pay_gb_eoy_archive.get_agg_active_end(paaf.assignment_id, p_tax_district, greatest(paaf.effective_start_date,papf.effective_start_date))
157: and pay_gb_eoy_archive.get_agg_active_start(paa.assignment_id, p_tax_district, greatest(paa.effective_start_date,ppf.effective_start_date))
158: = pay_gb_eoy_archive.get_agg_active_start(paaf.assignment_id, p_tax_district, greatest(paaf.effective_start_date,papf.effective_start_date))
159: and paaf.assignment_status_type_id = past.assignment_status_type_id

Line 156: = pay_gb_eoy_archive.get_agg_active_end(paaf.assignment_id, p_tax_district, greatest(paaf.effective_start_date,papf.effective_start_date))

152: and papf.payroll_id = paaf.payroll_id
153: and papf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
154: and hsck.segment1 = scl.segment1
155: and pay_gb_eoy_archive.get_agg_active_end(paa.assignment_id, p_tax_district, greatest(paa.effective_start_date,ppf.effective_start_date))
156: = pay_gb_eoy_archive.get_agg_active_end(paaf.assignment_id, p_tax_district, greatest(paaf.effective_start_date,papf.effective_start_date))
157: and pay_gb_eoy_archive.get_agg_active_start(paa.assignment_id, p_tax_district, greatest(paa.effective_start_date,ppf.effective_start_date))
158: = pay_gb_eoy_archive.get_agg_active_start(paaf.assignment_id, p_tax_district, greatest(paaf.effective_start_date,papf.effective_start_date))
159: and paaf.assignment_status_type_id = past.assignment_status_type_id
160: and past.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')

Line 157: and pay_gb_eoy_archive.get_agg_active_start(paa.assignment_id, p_tax_district, greatest(paa.effective_start_date,ppf.effective_start_date))

153: and papf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
154: and hsck.segment1 = scl.segment1
155: and pay_gb_eoy_archive.get_agg_active_end(paa.assignment_id, p_tax_district, greatest(paa.effective_start_date,ppf.effective_start_date))
156: = pay_gb_eoy_archive.get_agg_active_end(paaf.assignment_id, p_tax_district, greatest(paaf.effective_start_date,papf.effective_start_date))
157: and pay_gb_eoy_archive.get_agg_active_start(paa.assignment_id, p_tax_district, greatest(paa.effective_start_date,ppf.effective_start_date))
158: = pay_gb_eoy_archive.get_agg_active_start(paaf.assignment_id, p_tax_district, greatest(paaf.effective_start_date,papf.effective_start_date))
159: and paaf.assignment_status_type_id = past.assignment_status_type_id
160: and past.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
161: )

Line 158: = pay_gb_eoy_archive.get_agg_active_start(paaf.assignment_id, p_tax_district, greatest(paaf.effective_start_date,papf.effective_start_date))

154: and hsck.segment1 = scl.segment1
155: and pay_gb_eoy_archive.get_agg_active_end(paa.assignment_id, p_tax_district, greatest(paa.effective_start_date,ppf.effective_start_date))
156: = pay_gb_eoy_archive.get_agg_active_end(paaf.assignment_id, p_tax_district, greatest(paaf.effective_start_date,papf.effective_start_date))
157: and pay_gb_eoy_archive.get_agg_active_start(paa.assignment_id, p_tax_district, greatest(paa.effective_start_date,ppf.effective_start_date))
158: = pay_gb_eoy_archive.get_agg_active_start(paaf.assignment_id, p_tax_district, greatest(paaf.effective_start_date,papf.effective_start_date))
159: and paaf.assignment_status_type_id = past.assignment_status_type_id
160: and past.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
161: )
162: group by ele.rowid, scl.segment1,