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_ZA_EOY_VAL dependencies on PAY_ALL_PAYROLLS_F

Line 222: from pay_all_payrolls_f pap,

218: --checks would anyway get the latest payroll details
219:
220: select count(*)
221: into v_count
222: from pay_all_payrolls_f pap,
223: hr_soft_coding_keyflex scl
224: where pap.business_group_id = (select pap2.business_group_id from pay_all_payrolls_f pap2 where pap2.payroll_id=p_payroll_id and rownum=1)
225: and pap.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
226: and scl.segment8 = p_irp5no

Line 224: where pap.business_group_id = (select pap2.business_group_id from pay_all_payrolls_f pap2 where pap2.payroll_id=p_payroll_id and rownum=1)

220: select count(*)
221: into v_count
222: from pay_all_payrolls_f pap,
223: hr_soft_coding_keyflex scl
224: where pap.business_group_id = (select pap2.business_group_id from pay_all_payrolls_f pap2 where pap2.payroll_id=p_payroll_id and rownum=1)
225: and pap.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
226: and scl.segment8 = p_irp5no
227: and to_date(v_tax_end_date,'DD-MM-YYYY') between pap.effective_start_date and pap.effective_end_date;
228: if v_count > 1 then