APPS.PAY_FR_DADS_EMP_PKG dependencies on FND_TERRITORIES_TL

Line 80: , fnd_territories_tl ft_tl

76: , per_all_assignments_f paf
77: , pay_assignment_actions paa
78: , per_addresses pa
79: , fnd_territories ft
80: , fnd_territories_tl ft_tl
81: , fnd_territories ft1
82: , fnd_territories_tl ft1_tl
83: , hr_organization_information org_est
84: , per_periods_of_service pps

Line 82: , fnd_territories_tl ft1_tl

78: , per_addresses pa
79: , fnd_territories ft
80: , fnd_territories_tl ft_tl
81: , fnd_territories ft1
82: , fnd_territories_tl ft1_tl
83: , hr_organization_information org_est
84: , per_periods_of_service pps
85: Where paa.assignment_action_id = g_assign_action_id
86: And paf.assignment_id = paa.assignment_id

Line 1062: ,fnd_territories_tl ft_tl

1058: ,hla.country country_code
1059: ,ft_tl.territory_short_name country_name
1060: From hr_locations_all hla
1061: ,fnd_territories ft
1062: ,fnd_territories_tl ft_tl
1063: Where location_id = p_asg_location
1064: And ft.territory_code = hla.country
1065: And ft_tl.territory_code (+) = ft.territory_code
1066: And ft_tl.language (+) = userenv('LANG');