APPS.PAY_NL_EOY_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 1009: l_concatenated_segments hr_soft_coding_keyflex.CONCATENATED_SEGMENTS%TYPE;

1005: )
1006:
1007: IS
1008:
1009: l_concatenated_segments hr_soft_coding_keyflex.CONCATENATED_SEGMENTS%TYPE;
1010: l_cagr_grade_def_id per_all_assignments_f.CAGR_GRADE_DEF_ID%TYPE;
1011: l_cagr_concatenated_segments per_cagr_grades_def.CONCATENATED_SEGMENTS%TYPE;
1012: l_effective_start_date per_all_assignments_f.EFFECTIVE_START_DATE%TYPE;
1013: l_effective_end_date per_all_assignments_f.EFFECTIVE_END_DATE%TYPE;

Line 1041: ,hr_soft_coding_keyflex scl

1037: ,asg.effective_end_date
1038: , scl.segment12 last_year_sal
1039: -- , ast.user_status --12608988 Removed for performance optimization
1040: from per_all_assignments_f asg
1041: ,hr_soft_coding_keyflex scl
1042: ,per_assignment_status_types ast
1043: where organization_id in
1044: (select pose.organization_id_child
1045: from per_org_structure_elements pose,per_org_structure_versions posv

Line 1262: ,hr_soft_coding_keyflex hsck

1258: ,paa.effective_end_date
1259: ,paa.object_version_number
1260: ,hsck.segment12
1261: from per_all_assignments_f paa
1262: ,hr_soft_coding_keyflex hsck
1263: ,per_assignment_status_types pas
1264: where person_id=p_person_id
1265: and paa.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id (+)
1266: and pas.assignment_status_type_id=paa.assignment_status_type_id

Line 1272: l_concatenated_segments hr_soft_coding_keyflex.CONCATENATED_SEGMENTS%TYPE;

1268: and pas.business_group_id IS NULL and pas.legislation_code IS NULL
1269: and p_effective_date between effective_start_date and effective_end_date;
1270:
1271:
1272: l_concatenated_segments hr_soft_coding_keyflex.CONCATENATED_SEGMENTS%TYPE;
1273: l_cagr_grade_def_id per_all_assignments_f.CAGR_GRADE_DEF_ID%TYPE;
1274: l_cagr_concatenated_segments per_cagr_grades_def.CONCATENATED_SEGMENTS%TYPE;
1275: l_effective_start_date per_all_assignments_f.EFFECTIVE_START_DATE%TYPE;
1276: l_effective_end_date per_all_assignments_f.EFFECTIVE_END_DATE%TYPE;