APPS.PAY_SE_ALECTA dependencies on HR_SOFT_CODING_KEYFLEX

Line 1094: ,hr_soft_coding_keyflex scl

1090: IS
1091: SELECT scl.segment2
1092: ,scl.segment8
1093: FROM per_all_assignments_f paa
1094: ,hr_soft_coding_keyflex scl
1095: ,pay_assignment_actions pasa
1096: WHERE pasa.assignment_action_id = p_assignment_action_id
1097: AND pasa.assignment_id = paa.assignment_id
1098: AND scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id

Line 2936: ,hr_soft_coding_keyflex scl

2932: IS
2933: SELECT scl.segment2
2934: ,paa.location_id
2935: FROM per_all_assignments_f paa
2936: ,hr_soft_coding_keyflex scl
2937: WHERE paa.assignment_id = p_assignment_id
2938: AND scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
2939: -- AND paa.primary_flag = 'Y'
2940: AND p_effective_date BETWEEN paa.effective_start_date

Line 3198: ,hr_soft_coding_keyflex scl

3194: IS
3195: SELECT scl.segment2
3196: ,paa.location_id
3197: FROM per_all_assignments_f paa
3198: ,hr_soft_coding_keyflex scl
3199: WHERE paa.assignment_id = p_assignment_id
3200: AND scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
3201: AND p_effective_date BETWEEN paa.effective_start_date
3202: AND paa.effective_end_date;

Line 3497: ,hr_soft_coding_keyflex scl

3493: ,GREATEST (effective_start_date, g_start_date)
3494: "EFF_START_DATE"
3495: ,LEAST (effective_end_date, g_end_date) "EFF_END_DATE"
3496: FROM per_all_assignments_f paa
3497: ,hr_soft_coding_keyflex scl
3498: WHERE paa.assignment_id = p_assignment_id
3499: AND paa.business_group_id = g_business_group_id
3500: AND scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
3501: AND paa.effective_start_date BETWEEN g_start_date AND g_end_date