DBA Data[Home] [Help]

APPS.PAY_DK_MIA_REPORT_PKG dependencies on HR_LOCATIONS

Line 301: from hr_organization_units hou, hr_organization_information hoi, hr_locations loc

297: CURSOR csr_get_sp_details(p_payroll_action_id NUMBER) is
298: SELECT hou.name , hoi.ORG_INFORMATION1,
299: substr((loc.ADDRESS_LINE_1||' '||loc.ADDRESS_LINE_2||' '||loc.ADDRESS_LINE_3),1,40),
300: substr((loc.POSTAL_CODE ||' ' || loc.TOWN_OR_CITY),1,40)
301: from hr_organization_units hou, hr_organization_information hoi, hr_locations loc
302: where hou.business_group_id = get_business_group_id(p_payroll_action_id) -- change the bg id
303: AND hoi.organization_id = hou.organization_id
304: and hoi.org_information_context='DK_SERVICE_PROVIDER_DETAILS'
305: and hou.location_id=loc.location_id;