APPS.PAY_NL_EOY_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 957: l_concatenated_segments hr_soft_coding_keyflex.CONCATENATED_SEGMENTS%TYPE;

953: )
954:
955: IS
956:
957: l_concatenated_segments hr_soft_coding_keyflex.CONCATENATED_SEGMENTS%TYPE;
958: l_cagr_grade_def_id per_all_assignments_f.CAGR_GRADE_DEF_ID%TYPE;
959: l_cagr_concatenated_segments per_cagr_grades_def.CONCATENATED_SEGMENTS%TYPE;
960: l_effective_start_date per_all_assignments_f.EFFECTIVE_START_DATE%TYPE;
961: l_effective_end_date per_all_assignments_f.EFFECTIVE_END_DATE%TYPE;

Line 989: ,hr_soft_coding_keyflex scl

985: ,asg.effective_end_date
986: , scl.segment12 last_year_sal
987: , ast.user_status
988: from per_all_assignments_f asg
989: ,hr_soft_coding_keyflex scl
990: , per_assignment_status_types ast
991: where organization_id in
992: (select pose.organization_id_child
993: from per_org_structure_elements pose,per_org_structure_versions posv

Line 1119: ,hr_soft_coding_keyflex hsck

1115: ,paa.effective_end_date
1116: ,paa.object_version_number
1117: ,hsck.segment12
1118: from per_all_assignments_f paa
1119: ,hr_soft_coding_keyflex hsck
1120: ,per_assignment_status_types pas
1121: where person_id=p_person_id
1122: and paa.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id (+)
1123: and pas.assignment_status_type_id=paa.assignment_status_type_id

Line 1129: l_concatenated_segments hr_soft_coding_keyflex.CONCATENATED_SEGMENTS%TYPE;

1125: and pas.business_group_id IS NULL and pas.legislation_code IS NULL
1126: and p_effective_date between effective_start_date and effective_end_date;
1127:
1128:
1129: l_concatenated_segments hr_soft_coding_keyflex.CONCATENATED_SEGMENTS%TYPE;
1130: l_cagr_grade_def_id per_all_assignments_f.CAGR_GRADE_DEF_ID%TYPE;
1131: l_cagr_concatenated_segments per_cagr_grades_def.CONCATENATED_SEGMENTS%TYPE;
1132: l_effective_start_date per_all_assignments_f.EFFECTIVE_START_DATE%TYPE;
1133: l_effective_end_date per_all_assignments_f.EFFECTIVE_END_DATE%TYPE;