DBA Data[Home] [Help]

APPS.HR_AU_TAX_API dependencies on HR_SOFT_CODING_KEYFLEX

Line 190: , hr_soft_coding_keyflex scl

186: ,p_effective_date date
187: ) is
188: select scl.segment2
189: from per_all_assignments_f asg
190: , hr_soft_coding_keyflex scl
191: where scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
192: and asg.effective_start_date <= p_effective_date
193: and asg.effective_end_date >= p_effective_date
194: and asg.assignment_id = p_assignment_id;

Line 1671: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

1667: l_cagr_grade_def_id number;
1668: l_cagr_concatenated_segments varchar2(2000);
1669: l_comment_id number;
1670: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%type;
1671: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
1672: l_no_managers_warning boolean;
1673: l_other_manager_warning boolean;
1674: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%type;
1675: l_people_group_id per_all_assignments_f.people_group_id%type;