APPS.PER_AU_ASG_LEG_HOOK dependencies on HR_SOFT_CODING_KEYFLEX

Line 35: , hr_soft_coding_keyflex hsc

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

Line 45: l_tax_unit_id hr_soft_coding_keyflex.segment1%type;

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