DBA Data[Home] [Help]

APPS.PER_DIF_STMT_REPORT dependencies on FND_TERRITORIES

Line 242: fnd_territories estab_ft,

238: hr_all_organization_units_tl comp_tl,
239: hr_organization_information estab_info,
240: hr_locations_all estab_loc,
241: hr_locations_all comp_loc,
242: fnd_territories estab_ft,
243: fnd_territories comp_ft
244: where estab.organization_id = p_estab_id
245: and estab.business_group_id = p_business_group_id
246: and estab_tl.organization_id = estab.organization_id

Line 243: fnd_territories comp_ft

239: hr_organization_information estab_info,
240: hr_locations_all estab_loc,
241: hr_locations_all comp_loc,
242: fnd_territories estab_ft,
243: fnd_territories comp_ft
244: where estab.organization_id = p_estab_id
245: and estab.business_group_id = p_business_group_id
246: and estab_tl.organization_id = estab.organization_id
247: and estab_tl.language = userenv('LANG')

Line 293: fnd_territories per_ft,

289: asg.assignment_id,
290: asg.payroll_id
291: from per_all_people_f per,
292: per_addresses per_addr,
293: fnd_territories per_ft,
294: per_periods_of_service serv,
295: per_all_assignments_f asg,
296: per_collective_agreements col_agr
297: where per.person_id = p_emp_id