DBA Data[Home] [Help]

APPS.PAY_IE_RULES dependencies on HR_SOFT_CODING_KEYFLEX

Line 41: hr_soft_coding_keyflex scl

37: CURSOR c_get_tex_unit_id(l_assignment_id number,l_effective_date date) IS
38: SELECT to_number(scl.segment4)
39: from per_all_assignments_f asg,
40: pay_all_payrolls_f papf,
41: hr_soft_coding_keyflex scl
42: where asg.business_group_id = papf.business_group_id
43: and papf.payroll_id = asg.payroll_id
44: and asg.assignment_id = l_assignment_id
45: and l_effective_date between asg.effective_start_date and asg.effective_end_date