DBA Data[Home] [Help]

APPS.PER_AE_MIGRATE_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 108: ,hr_soft_coding_keyflex hsc

104: ,paa.effective_start_date
105: ,paa.effective_end_date
106: ,0 indicator
107: FROM per_all_assignments_f paa
108: ,hr_soft_coding_keyflex hsc
109: WHERE person_id = p_person_id
110: AND paa.primary_flag = 'Y'
111: AND hsc.soft_coding_keyflex_id(+) = paa.soft_coding_keyflex_id
112: AND ((paa.effective_start_date BETWEEN p_start_date AND p_end_date ))

Line 126: ,hr_soft_coding_keyflex hsc

122: ,paa.effective_start_date
123: ,paa.effective_end_date
124: ,1 indicator
125: FROM per_all_assignments_f paa
126: ,hr_soft_coding_keyflex hsc
127: WHERE person_id = p_person_id
128: AND paa.primary_flag = 'Y'
129: AND hsc.soft_coding_keyflex_id(+) = paa.soft_coding_keyflex_id
130: AND ((paa.effective_start_date < p_start_date AND paa.effective_end_date >= p_end_date))