APPS.PER_QH_SUMMARY_QUERY dependencies on FND_TERRITORIES_VL

Line 329: ,style_meaning fnd_territories_vl.territory_short_name%type

325: ,adjusted_svc_date per_periods_of_service.adjusted_svc_date%type
326: ,hire_date per_periods_of_service.date_start%type
327: ,adr_date_from per_addresses.date_from%type
328: ,style per_addresses.style%type
329: ,style_meaning fnd_territories_vl.territory_short_name%type
330: ,address_line1 per_addresses.address_line1%type
331: ,address_line2 per_addresses.address_line2%type
332: ,address_line3 per_addresses.address_line3%type
333: ,address_type_meaning hr_lookups.meaning%type

Line 420: ,country1_meaning fnd_territories_vl.territory_short_name%type

416: ,work_any_location per_deployment_factors.work_any_location%type
417: ,relocate_domestically per_deployment_factors.relocate_domestically%type
418: ,relocate_internationally per_deployment_factors.relocate_internationally%type
419: ,travel_required per_deployment_factors.travel_required%type
420: ,country1_meaning fnd_territories_vl.territory_short_name%type
421: ,country2_meaning fnd_territories_vl.territory_short_name%type
422: ,country3_meaning fnd_territories_vl.territory_short_name%type
423: ,dpf_work_duration_meaning hr_lookups.meaning%type
424: ,dpf_work_schedule_meaning hr_lookups.meaning%type

Line 421: ,country2_meaning fnd_territories_vl.territory_short_name%type

417: ,relocate_domestically per_deployment_factors.relocate_domestically%type
418: ,relocate_internationally per_deployment_factors.relocate_internationally%type
419: ,travel_required per_deployment_factors.travel_required%type
420: ,country1_meaning fnd_territories_vl.territory_short_name%type
421: ,country2_meaning fnd_territories_vl.territory_short_name%type
422: ,country3_meaning fnd_territories_vl.territory_short_name%type
423: ,dpf_work_duration_meaning hr_lookups.meaning%type
424: ,dpf_work_schedule_meaning hr_lookups.meaning%type
425: ,dpf_work_hours_meaning hr_lookups.meaning%type

Line 422: ,country3_meaning fnd_territories_vl.territory_short_name%type

418: ,relocate_internationally per_deployment_factors.relocate_internationally%type
419: ,travel_required per_deployment_factors.travel_required%type
420: ,country1_meaning fnd_territories_vl.territory_short_name%type
421: ,country2_meaning fnd_territories_vl.territory_short_name%type
422: ,country3_meaning fnd_territories_vl.territory_short_name%type
423: ,dpf_work_duration_meaning hr_lookups.meaning%type
424: ,dpf_work_schedule_meaning hr_lookups.meaning%type
425: ,dpf_work_hours_meaning hr_lookups.meaning%type
426: ,dpf_fte_capacity_meaning hr_lookups.meaning%type

Line 429: ,no_country1_meaning fnd_territories_vl.territory_short_name%type

425: ,dpf_work_hours_meaning hr_lookups.meaning%type
426: ,dpf_fte_capacity_meaning hr_lookups.meaning%type
427: ,visit_internationally per_deployment_factors.visit_internationally%type
428: ,only_current_location per_deployment_factors.only_current_location%type
429: ,no_country1_meaning fnd_territories_vl.territory_short_name%type
430: ,no_country2_meaning fnd_territories_vl.territory_short_name%type
431: ,no_country3_meaning fnd_territories_vl.territory_short_name%type
432: ,earliest_available_date per_deployment_factors.earliest_available_date%type
433: ,available_for_transfer per_deployment_factors.available_for_transfer%type

Line 430: ,no_country2_meaning fnd_territories_vl.territory_short_name%type

426: ,dpf_fte_capacity_meaning hr_lookups.meaning%type
427: ,visit_internationally per_deployment_factors.visit_internationally%type
428: ,only_current_location per_deployment_factors.only_current_location%type
429: ,no_country1_meaning fnd_territories_vl.territory_short_name%type
430: ,no_country2_meaning fnd_territories_vl.territory_short_name%type
431: ,no_country3_meaning fnd_territories_vl.territory_short_name%type
432: ,earliest_available_date per_deployment_factors.earliest_available_date%type
433: ,available_for_transfer per_deployment_factors.available_for_transfer%type
434: ,relocation_pref_meaning hr_lookups.meaning%type

Line 431: ,no_country3_meaning fnd_territories_vl.territory_short_name%type

427: ,visit_internationally per_deployment_factors.visit_internationally%type
428: ,only_current_location per_deployment_factors.only_current_location%type
429: ,no_country1_meaning fnd_territories_vl.territory_short_name%type
430: ,no_country2_meaning fnd_territories_vl.territory_short_name%type
431: ,no_country3_meaning fnd_territories_vl.territory_short_name%type
432: ,earliest_available_date per_deployment_factors.earliest_available_date%type
433: ,available_for_transfer per_deployment_factors.available_for_transfer%type
434: ,relocation_pref_meaning hr_lookups.meaning%type
435: ,relocation_preference per_deployment_factors.relocation_preference%type