DBA Data[Home] [Help]

APPS.PAY_ZA_IRP5_IT3A_XMLP_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 81: FROM hr_soft_coding_keyflex kff, pay_all_payrolls_f ppf

77: -- -----------------------------------------------------------------------------
78: FUNCTION get_payroll_ref (p_payroll_id varchar2) return varchar2 IS
79: CURSOR get_payroll_ref IS
80: SELECT lpad(segment8,6,'0')
81: FROM hr_soft_coding_keyflex kff, pay_all_payrolls_f ppf
82: WHERE ppf.soft_coding_keyflex_id = kff.soft_coding_keyflex_id
83: AND ppf.payroll_id = p_payroll_id
84: AND g_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date;
85: