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_SYNC dependencies on PAY_GB_EOY_ARCHIVE

Line 113: pay_gb_eoy_archive.get_agg_active_start(paaf.assignment_id, c_taxref, c_effective_date) cpe_start,

109: SELECT papf.last_name lname,
110: paaf.person_id pid,
111: paaf.assignment_id aid,
112: paaf.assignment_number anum,
113: pay_gb_eoy_archive.get_agg_active_start(paaf.assignment_id, c_taxref, c_effective_date) cpe_start,
114: -- pay_gb_eoy_archive.get_agg_active_end(paaf.assignment_id, c_taxref, c_effective_date) cpe_end,
115: peef.effective_start_date effst,
116: peef.effective_end_date effend,
117: peef.object_version_number ovn,

Line 114: -- pay_gb_eoy_archive.get_agg_active_end(paaf.assignment_id, c_taxref, c_effective_date) cpe_end,

110: paaf.person_id pid,
111: paaf.assignment_id aid,
112: paaf.assignment_number anum,
113: pay_gb_eoy_archive.get_agg_active_start(paaf.assignment_id, c_taxref, c_effective_date) cpe_start,
114: -- pay_gb_eoy_archive.get_agg_active_end(paaf.assignment_id, c_taxref, c_effective_date) cpe_end,
115: peef.effective_start_date effst,
116: peef.effective_end_date effend,
117: peef.object_version_number ovn,
118: min(decode(pivf.name, 'Tax Code', peevf.screen_entry_value, null)) Tax_Code,

Line 151: /*AND c_effective_date between pay_gb_eoy_archive.get_agg_active_start (paaf.assignment_id, c_taxref,c_effective_date)

147: AND c_effective_date BETWEEN pap.effective_start_date AND pap.effective_end_date
148: --AND pap.soft_coding_keyflex_id= c_sft_coding_id
149: AND pap.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
150: AND hsck.segment1 = c_taxref
151: /*AND c_effective_date between pay_gb_eoy_archive.get_agg_active_start (paaf.assignment_id, c_taxref,c_effective_date)
152: AND pay_gb_eoy_archive.get_agg_active_end(paaf.assignment_id, c_taxref,c_effective_date) */
153: AND pay_gb_eoy_archive.get_agg_active_start(paaf.assignment_id, c_taxref,c_effective_date) = c_cpe_start_date
154: AND pay_p45_pkg.PAYE_SYNC_P45_ISSUED_FLAG(paaf.assignment_id,l_effective_date) = 'N'
155: group by papf.last_name,

Line 152: AND pay_gb_eoy_archive.get_agg_active_end(paaf.assignment_id, c_taxref,c_effective_date) */

148: --AND pap.soft_coding_keyflex_id= c_sft_coding_id
149: AND pap.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
150: AND hsck.segment1 = c_taxref
151: /*AND c_effective_date between pay_gb_eoy_archive.get_agg_active_start (paaf.assignment_id, c_taxref,c_effective_date)
152: AND pay_gb_eoy_archive.get_agg_active_end(paaf.assignment_id, c_taxref,c_effective_date) */
153: AND pay_gb_eoy_archive.get_agg_active_start(paaf.assignment_id, c_taxref,c_effective_date) = c_cpe_start_date
154: AND pay_p45_pkg.PAYE_SYNC_P45_ISSUED_FLAG(paaf.assignment_id,l_effective_date) = 'N'
155: group by papf.last_name,
156: paaf.person_id,

Line 153: AND pay_gb_eoy_archive.get_agg_active_start(paaf.assignment_id, c_taxref,c_effective_date) = c_cpe_start_date

149: AND pap.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
150: AND hsck.segment1 = c_taxref
151: /*AND c_effective_date between pay_gb_eoy_archive.get_agg_active_start (paaf.assignment_id, c_taxref,c_effective_date)
152: AND pay_gb_eoy_archive.get_agg_active_end(paaf.assignment_id, c_taxref,c_effective_date) */
153: AND pay_gb_eoy_archive.get_agg_active_start(paaf.assignment_id, c_taxref,c_effective_date) = c_cpe_start_date
154: AND pay_p45_pkg.PAYE_SYNC_P45_ISSUED_FLAG(paaf.assignment_id,l_effective_date) = 'N'
155: group by papf.last_name,
156: paaf.person_id,
157: paaf.assignment_number,

Line 162: pay_gb_eoy_archive.get_agg_active_start(paaf.assignment_id, c_taxref, c_effective_date)

158: paaf.assignment_id,
159: peef.effective_start_date,
160: peef.effective_end_date,
161: peef.object_version_number,
162: pay_gb_eoy_archive.get_agg_active_start(paaf.assignment_id, c_taxref, c_effective_date)
163: -- pay_gb_eoy_archive.get_agg_active_end(paaf.assignment_id, c_taxref, c_effective_date)
164: order by peef.effective_start_date desc,paaf.assignment_id desc;
165:
166:

Line 163: -- pay_gb_eoy_archive.get_agg_active_end(paaf.assignment_id, c_taxref, c_effective_date)

159: peef.effective_start_date,
160: peef.effective_end_date,
161: peef.object_version_number,
162: pay_gb_eoy_archive.get_agg_active_start(paaf.assignment_id, c_taxref, c_effective_date)
163: -- pay_gb_eoy_archive.get_agg_active_end(paaf.assignment_id, c_taxref, c_effective_date)
164: order by peef.effective_start_date desc,paaf.assignment_id desc;
165:
166:
167: out_name varchar2(1000);

Line 203: pay_gb_eoy_archive.get_agg_active_start (paaf.assignment_id, l_tax_ref,l_effective_date) cpe_date

199: min(decode(inv.name, 'Refundable', eev.screen_entry_value, null)) Refundable,
200: min(decode(inv.name, 'Pay Previous', nvl(eev.screen_entry_value,0), null)) Pay_Previous,
201: min(decode(inv.name, 'Tax Previous', nvl(eev.screen_entry_value,0), null)) Tax_Previous,
202: min(decode(inv.name, 'Authority', eev.screen_entry_value, null)) Authority,
203: pay_gb_eoy_archive.get_agg_active_start (paaf.assignment_id, l_tax_ref,l_effective_date) cpe_date
204: FROM pay_element_entries_f ele,
205: pay_element_entry_values_f eev,
206: pay_input_values_f inv,
207: pay_element_links_f lnk,

Line 230: AND pay_gb_eoy_archive.get_agg_active_start(paaf.assignment_id, l_tax_ref,l_effective_date) <> l_cpe_start_date

226: AND papf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
227: AND hsck.segment1 = l_tax_ref
228: AND paaf.person_id = c_person_id
229: AND pay_p45_pkg.PAYE_SYNC_P45_ISSUED_FLAG(paaf.assignment_id,l_effective_date) = 'N'
230: AND pay_gb_eoy_archive.get_agg_active_start(paaf.assignment_id, l_tax_ref,l_effective_date) <> l_cpe_start_date
231: GROUP BY pay_gb_eoy_archive.get_agg_active_start (paaf.assignment_id, l_tax_ref,l_effective_date),
232: ele.rowid) ppev )
233: GROUP BY cpe_date;
234:

Line 231: GROUP BY pay_gb_eoy_archive.get_agg_active_start (paaf.assignment_id, l_tax_ref,l_effective_date),

227: AND hsck.segment1 = l_tax_ref
228: AND paaf.person_id = c_person_id
229: AND pay_p45_pkg.PAYE_SYNC_P45_ISSUED_FLAG(paaf.assignment_id,l_effective_date) = 'N'
230: AND pay_gb_eoy_archive.get_agg_active_start(paaf.assignment_id, l_tax_ref,l_effective_date) <> l_cpe_start_date
231: GROUP BY pay_gb_eoy_archive.get_agg_active_start (paaf.assignment_id, l_tax_ref,l_effective_date),
232: ele.rowid) ppev )
233: GROUP BY cpe_date;
234:
235: /*--------------------------------------------------------------*/

Line 705: pay_gb_eoy_archive.get_agg_active_start(paaf.assignment_id, P_IN_TAX_DISTRICT, P_EFF_DATE) cpe_start_date,

701: paaf.assignment_number,
702: paaf.payroll_id,
703: peef.effective_start_date,
704: peef.effective_end_date,
705: pay_gb_eoy_archive.get_agg_active_start(paaf.assignment_id, P_IN_TAX_DISTRICT, P_EFF_DATE) cpe_start_date,
706: --paaf.object_version_number,
707: peef.element_entry_id,
708: peef.creator_id,
709: peef.object_version_number,

Line 764: pay_gb_eoy_archive.get_agg_active_start(paaf.assignment_id, P_IN_TAX_DISTRICT, P_EFF_DATE),

760: paaf.assignment_number,
761: paaf.payroll_id,
762: peef.effective_start_date,
763: peef.effective_end_date,
764: pay_gb_eoy_archive.get_agg_active_start(paaf.assignment_id, P_IN_TAX_DISTRICT, P_EFF_DATE),
765: --paaf.object_version_number,
766: peef.element_entry_id,
767: peef.creator_id,
768: peef.object_version_number;