DBA Data[Home] [Help]

APPS.HR_AU_TAX_API dependencies on HR_SOFT_CODING_KEYFLEX

Line 202: , hr_soft_coding_keyflex scl

198: ,p_effective_date date
199: ) is
200: select scl.segment2
201: from per_all_assignments_f asg
202: , hr_soft_coding_keyflex scl
203: where scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
204: and asg.effective_start_date <= p_effective_date
205: and asg.effective_end_date >= p_effective_date
206: and asg.assignment_id = p_assignment_id;

Line 1713: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

1709: l_cagr_grade_def_id number;
1710: l_cagr_concatenated_segments varchar2(2000);
1711: l_comment_id number;
1712: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%type;
1713: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
1714: l_no_managers_warning boolean;
1715: l_other_manager_warning boolean;
1716: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%type;
1717: l_people_group_id per_all_assignments_f.people_group_id%type;