APPS.PER_AU_ASG_LEG_HOOK dependencies on HR_SOFT_CODING_KEYFLEX

Line 34: , hr_soft_coding_keyflex hsc

30: ,c_effective_date DATE
31: ) IS
32: SELECT hsc.segment1
33: FROM per_all_assignments_f a
34: , hr_soft_coding_keyflex hsc
35: WHERE a.assignment_id = c_assignment_id
36: AND hsc.soft_coding_keyflex_id = a.soft_coding_keyflex_id
37: AND c_effective_date BETWEEN a.effective_start_date AND a.effective_end_date;
38: g_debug BOOLEAN;

Line 44: l_tax_unit_id hr_soft_coding_keyflex.segment1%type;

40: l_eff_start_date DATE;
41: l_eff_end_date DATE;
42: l_business_group_id NUMBER;
43: l_actions_exist VARCHAR2(3);
44: l_tax_unit_id hr_soft_coding_keyflex.segment1%type;
45: BEGIN
46: g_debug := hr_utility.debug_enabled;
47:
48: IF g_debug THEN