APPS.PER_SG_ASG_LEG_HOOK dependencies on HR_SOFT_CODING_KEYFLEX

Line 17: , hr_soft_coding_keyflex hsc

13: ,c_effective_date DATE
14: ) IS
15: SELECT hsc.segment1, business_group_id
16: FROM per_all_assignments_f a
17: , hr_soft_coding_keyflex hsc
18: WHERE a.assignment_id = c_assignment_id
19: AND hsc.soft_coding_keyflex_id = a.soft_coding_keyflex_id
20: AND c_effective_date BETWEEN a.effective_start_date AND a.effective_end_date;
21:

Line 26: l_tax_unit_id hr_soft_coding_keyflex.segment1%TYPE;

22: g_debug BOOLEAN;
23: l_bg_id per_business_groups.business_group_id%TYPE;
24: l_future_actions_exist VARCHAR2(10);
25: l_actions_exist VARCHAR2(10);
26: l_tax_unit_id hr_soft_coding_keyflex.segment1%TYPE;
27:
28: /* This Cursor Checks returns 'YES' when the LE of
29: the given assignment is changed and there exists
30: actions in the period or in future periods */