DBA Data[Home] [Help]

APPS.PAY_ES_SS_CALCULATION dependencies on HR_SOFT_CODING_KEYFLEX

Line 58: ,hr_soft_coding_keyflex scl

54: ,c_effective_date DATE) IS
55: SELECT segment5
56: ,segment2
57: FROM per_all_assignments_f paaf
58: ,hr_soft_coding_keyflex scl
59: WHERE paaf.assignment_id = c_assignment_id
60: AND paaf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
61: AND c_effective_date between paaf.effective_start_date and paaf.effective_end_date;
62: --

Line 1248: ,hr_soft_coding_keyflex scl

1244: ,c_effective_date DATE) IS
1245: SELECT segment5
1246: ,segment2
1247: FROM per_all_assignments_f paaf
1248: ,hr_soft_coding_keyflex scl
1249: WHERE paaf.assignment_id = c_assignment_id
1250: AND paaf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
1251: AND c_effective_date between paaf.effective_start_date and paaf.effective_end_date;
1252: --