eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_DK_MIA_REPORT_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 272: (select organization_id from hr_organization_information where org_information_context = 'DK_SERVICE_PROVIDER_DETAILS')

268: FUNCTION get_sp_name(p_business_group_id IN NUMBER) RETURN VARCHAR2 as
269:
270: CURSOR csr_get_sp_name(p_business_group_id NUMBER) is
271: SELECT name from hr_organization_units where organization_id =
272: (select organization_id from hr_organization_information where org_information_context = 'DK_SERVICE_PROVIDER_DETAILS')
273: and business_group_id = p_business_group_id;
274:
275: l_sp_name VARCHAR2(50);
276:

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;