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.CREATE_GB_RTI_EPS_RECORD dependencies on HR_SOFT_CODING_KEYFLEX

Line 222: hr_soft_coding_keyflex flex,

218: -- Effective date, Business_group_id, PAYE reference, tax_year_start and Tax_year_end
219: -- To fetch all payrolls belonging to this PAYE reference.
220: SELECT DISTINCT papf.payroll_id
221: FROM pay_all_payrolls_f papf,
222: hr_soft_coding_keyflex flex,
223: per_time_periods ptp
224: WHERE papf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
225: AND flex.segment1 = p_paye_reference
226: AND flex.segment10 IS NOT NULL

Line 474: select SEGMENT1 into g_paye_reference from hr_soft_coding_keyflex hr , pay_payrolls_f p

470: pay_assignment_Actions paa
471: where paa.PAYROLL_ACTION_ID = ppa.payroll_Action_id
472: and paa.assignment_action_id = p_assignment_action_id;
473:
474: select SEGMENT1 into g_paye_reference from hr_soft_coding_keyflex hr , pay_payrolls_f p
475: where hr.SOFT_CODING_KEYFLEX_ID = p.SOFT_CODING_KEYFLEX_ID
476: and p.payroll_id = l_payroll_id
477: and l_eff_date between effective_start_date and effective_end_date;
478:

Line 475: where hr.SOFT_CODING_KEYFLEX_ID = p.SOFT_CODING_KEYFLEX_ID

471: where paa.PAYROLL_ACTION_ID = ppa.payroll_Action_id
472: and paa.assignment_action_id = p_assignment_action_id;
473:
474: select SEGMENT1 into g_paye_reference from hr_soft_coding_keyflex hr , pay_payrolls_f p
475: where hr.SOFT_CODING_KEYFLEX_ID = p.SOFT_CODING_KEYFLEX_ID
476: and p.payroll_id = l_payroll_id
477: and l_eff_date between effective_start_date and effective_end_date;
478:
479: --load the profile values