APPS.GMF_GET_TRANSFER_PRICE_PUB dependencies on HR_ORGANIZATION_INFORMATION

Line 271: FROM hr_organization_information src

267:
268: --Begin Bug 7713946
269: SELECT to_number(src.org_information3) src_ou
270: INTO g_from_ou
271: FROM hr_organization_information src
272: WHERE src.organization_id = g_from_organization_id
273: AND src.org_information_context = 'Accounting Information';
274:
275: SELECT to_number(dest.org_information3) dest_ou

Line 277: FROM hr_organization_information dest

273: AND src.org_information_context = 'Accounting Information';
274:
275: SELECT to_number(dest.org_information3) dest_ou
276: INTO g_to_ou
277: FROM hr_organization_information dest
278: WHERE dest.organization_id = g_to_organization_id
279: AND dest.org_information_context = 'Accounting Information';
280:
281: print_debug(l_api_name || ' g_from_ou: ' || g_from_ou);

Line 309: FROM hr_organization_information org, gl_ledgers gll

305: -- Fixed following sql for performance issue
306: --===================================================================
307: SELECT currency_code
308: INTO g_from_org_currency
309: FROM hr_organization_information org, gl_ledgers gll
310: WHERE org.organization_id = g_from_organization_id
311: AND gll.ledger_id = org.org_information1
312: AND org.org_information_context = 'Accounting Information';
313: