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_RTI_P60 dependencies on HR_GBBAL

Line 3110: AND p.effective_start_date <= hr_gbbal.span_end(p_end_year)

3106: FROM pay_all_payrolls_f p,
3107: hr_soft_coding_keyflex flex
3108: WHERE p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id(+)
3109: AND p.payroll_id = p_payroll_id
3110: AND p.effective_start_date <= hr_gbbal.span_end(p_end_year)
3111: AND p.effective_end_date >= hr_gbbal.span_start(p_end_year)
3112: AND nvl(flex.segment1, 'XYZ') <> nvl(p_paye_ref, 'ABC');
3113: --
3114: l_another_paye_ref hr_soft_coding_keyflex.segment1%TYPE;

Line 3111: AND p.effective_end_date >= hr_gbbal.span_start(p_end_year)

3107: hr_soft_coding_keyflex flex
3108: WHERE p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id(+)
3109: AND p.payroll_id = p_payroll_id
3110: AND p.effective_start_date <= hr_gbbal.span_end(p_end_year)
3111: AND p.effective_end_date >= hr_gbbal.span_start(p_end_year)
3112: AND nvl(flex.segment1, 'XYZ') <> nvl(p_paye_ref, 'ABC');
3113: --
3114: l_another_paye_ref hr_soft_coding_keyflex.segment1%TYPE;
3115: --