DBA Data[Home] [Help]

APPS.PQP_ALIEN_EXPAT_TAXATION_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 1409: hr_soft_coding_keyflex hrsckf,

1405: NVL(hrlock.telephone_number_2 , ' ' ) telephone_number_2,
1406: NVL(hrlock.telephone_number_3 , ' ' ) telephone_number_3,
1407: NVL(hrlock.postal_code , ' ' ) postal_code
1408: from hr_locations hrlock,
1409: hr_soft_coding_keyflex hrsckf,
1410: per_all_assignments_f assign
1411: where p_effective_date between assign.effective_start_date
1412: and assign.effective_end_date
1413: and assign.assignment_id = p_per_assign_id

Line 3322: ,hr_soft_coding_keyflex hrsckf

3318: select nvl(hrlock.loc_information17
3319: ,hrlock.region_2) state
3320:
3321: from hr_locations hrlock
3322: ,hr_soft_coding_keyflex hrsckf
3323: ,per_all_assignments_f paf
3324:
3325: where paf.effective_start_date <=
3326: to_date(('12/31/'||to_char(p_effective_date,'YYYY')),'MM/DD/YYYY')