APPS.PAY_SE_INCOME_STATEMENT dependencies on HR_SOFT_CODING_KEYFLEX

Line 962: ,hr_soft_coding_keyflex scl

958: ,paa.effective_start_date
959: ,paa.effective_end_date
960: ,scl.segment2
961: FROM per_all_assignments_f paa
962: ,hr_soft_coding_keyflex scl
963: WHERE person_id = csr_v_person_id
964: AND paa.effective_start_date <= g_income_end_date
965: AND paa.effective_end_date > = g_income_start_date
966: AND paa.primary_flag = 'Y'

Line 2019: ,hr_soft_coding_keyflex scl

2015: IS
2016: SELECT MIN (paa.effective_start_date) effective_start_date
2017: ,MAX (paa.effective_end_date) effective_end_date
2018: FROM per_all_assignments_f paa
2019: ,hr_soft_coding_keyflex scl
2020: WHERE person_id = csr_v_person_id
2021: AND paa.effective_start_date <= g_income_end_date
2022: AND paa.effective_end_date > = g_income_start_date
2023: AND assignment_status_type_id IN (

Line 2070: ,hr_soft_coding_keyflex scl

2066: IS
2067: SELECT scl.segment2
2068: ,scl.segment8
2069: FROM per_all_assignments_f paa
2070: ,hr_soft_coding_keyflex scl
2071: ,pay_assignment_actions pasa
2072: WHERE pasa.assignment_action_id = p_assignment_action_id
2073: AND pasa.assignment_id = paa.assignment_id
2074: AND scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id

Line 2130: ,hr_soft_coding_keyflex scl

2126: ,paa.effective_start_date
2127: ,paa.effective_end_date
2128: ,scl.segment2
2129: FROM per_all_assignments_f paa
2130: ,hr_soft_coding_keyflex scl
2131: WHERE paa.person_id = csr_v_person_id
2132: AND paa.effective_start_date <= g_income_end_date
2133: AND paa.effective_end_date > = g_income_start_date
2134: AND paa.assignment_status_type_id IN (

Line 2155: ,hr_soft_coding_keyflex scl

2151: ,paa.effective_start_date
2152: ,paa.effective_end_date
2153: ,scl.segment2
2154: FROM per_all_assignments_f paa
2155: ,hr_soft_coding_keyflex scl
2156: WHERE person_id = csr_v_person_id
2157: AND paa.effective_start_date <= g_income_end_date
2158: AND paa.effective_end_date > = g_income_start_date
2159: AND paa.primary_flag = 'Y'