DBA Data[Home] [Help]

APPS.CREATE_GB_RTI_EPS_RECORD dependencies on PAY_PAYROLLS_F

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: