APPS.PQP_ALIEN_EXPAT_TAXATION_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 1405: hr_soft_coding_keyflex hrsckf,

1401: NVL(hrlock.telephone_number_2 , ' ' ) telephone_number_2,
1402: NVL(hrlock.telephone_number_3 , ' ' ) telephone_number_3,
1403: NVL(hrlock.postal_code , ' ' ) postal_code
1404: from hr_locations hrlock,
1405: hr_soft_coding_keyflex hrsckf,
1406: per_all_assignments_f assign
1407: where p_effective_date between assign.effective_start_date
1408: and assign.effective_end_date
1409: and assign.assignment_id = p_per_assign_id

Line 3316: ,hr_soft_coding_keyflex hrsckf

3312: select nvl(hrlock.loc_information17
3313: ,hrlock.region_2) state
3314:
3315: from hr_locations hrlock
3316: ,hr_soft_coding_keyflex hrsckf
3317: ,per_all_assignments_f paf
3318:
3319: where paf.effective_start_date <=
3320: to_date(('12/31/'||to_char(p_effective_date,'YYYY')),'MM/DD/YYYY')