DBA Data[Home] [Help]

APPS.PAY_FR_ARC_PKG dependencies on HR_LOCATIONS_ALL

Line 995: hr_locations_all addr

991: hr_organization_information est_info,
992: hr_all_organization_units comp,
993: hr_all_organization_units_tl comptl,
994: hr_organization_information comp_info,
995: hr_locations_all addr
996: where addr.location_id(+) = comp.location_id
997: and comptl.organization_id = comp.organization_id
998: and comptl.language = userenv('lang')
999: and comp_info.organization_id(+) = comp.organization_id

Line 1045: hr_locations_all addr

1041: substr(addr.region_3,1,150) region_3,
1042: addr.town_or_city,
1043: addr.postal_code
1044: from pay_action_information pai,
1045: hr_locations_all addr
1046: where addr.location_id = pai.ACTION_INFORMATION2
1047: and pai.action_context_type = 'PA'
1048: and pai.action_information_category in ('FR_SOE_COMPANY_DETAILS',
1049: 'FR_SOE_ESTAB_INFORMATION')