APPS.PAY_SE_ALECTA dependencies on HR_SOFT_CODING_KEYFLEX

Line 1047: ,hr_soft_coding_keyflex scl

1043: IS
1044: SELECT scl.segment2
1045: ,scl.segment8
1046: FROM per_all_assignments_f paa
1047: ,hr_soft_coding_keyflex scl
1048: ,pay_assignment_actions pasa
1049: WHERE pasa.assignment_action_id = p_assignment_action_id
1050: AND pasa.assignment_id = paa.assignment_id
1051: AND scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id

Line 2508: ,hr_soft_coding_keyflex scl

2504: IS
2505: SELECT scl.segment2
2506: ,paa.location_id
2507: FROM per_all_assignments_f paa
2508: ,hr_soft_coding_keyflex scl
2509: WHERE paa.assignment_id = p_assignment_id
2510: AND scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
2511: -- AND paa.primary_flag = 'Y'
2512: AND p_effective_date BETWEEN paa.effective_start_date

Line 2770: ,hr_soft_coding_keyflex scl

2766: IS
2767: SELECT scl.segment2
2768: ,paa.location_id
2769: FROM per_all_assignments_f paa
2770: ,hr_soft_coding_keyflex scl
2771: WHERE paa.assignment_id = p_assignment_id
2772: AND scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
2773: AND p_effective_date BETWEEN paa.effective_start_date
2774: AND paa.effective_end_date;

Line 3050: ,hr_soft_coding_keyflex scl

3046: ,GREATEST (effective_start_date, g_start_date)
3047: "EFF_START_DATE"
3048: ,LEAST (effective_end_date, g_end_date) "EFF_END_DATE"
3049: FROM per_all_assignments_f paa
3050: ,hr_soft_coding_keyflex scl
3051: WHERE paa.assignment_id = p_assignment_id
3052: AND paa.business_group_id = g_business_group_id
3053: AND scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
3054: AND paa.effective_start_date BETWEEN g_start_date AND g_end_date