APPS.CSP_PARTS_ORDER dependencies on HR_ORGANIZATION_INFORMATION

Line 35: hr_organization_information hoi

31: CURSOR currency_code_cur (p_organization_id NUMBER) IS
32: SELECT glsob.currency_code
33: ,glsob.chart_of_accounts_id
34: FROM gl_sets_of_books glsob,
35: hr_organization_information hoi
36: WHERE glsob.set_of_books_id = hoi.org_information1
37: AND hoi.org_information_context ||'' = 'Accounting Information'
38: AND hoi.organization_id = p_organization_id;
39:

Line 62: hr_organization_information hoi,

58: psp.DEFAULT_RATE_TYPE,
59: 30),10)
60: FROM mtl_system_items msi,
61: gl_sets_of_books glsob,
62: hr_organization_information hoi,
63: po_system_parameters psp
64: WHERE msi.inventory_item_id = p_item_id
65: AND hoi.organization_id = p_source_organization_id
66: AND hoi.org_information_context = 'Accounting Information'

Line 78: hr_organization_information hoi,

74: trunc(sysdate),
75: psp.DEFAULT_RATE_TYPE,
76: 30),10)
77: FROM gl_sets_of_books glsob,
78: hr_organization_information hoi,
79: po_system_parameters psp
80: WHERE hoi.organization_id = p_source_organization_id
81: AND HOI.ORG_INFORMATION_CONTEXT = 'Accounting Information'
82: AND glsob.set_of_books_id = hoi.org_information1;

Line 478: FROM hr_organization_information hou

474: CURSOR get_new_context(p_new_org_id number) IS
475: SELECT org_information2 ,
476: org_information3 ,
477: org_information4
478: FROM hr_organization_information hou
479: WHERE hou.organization_id = p_new_org_id
480: AND hou.org_information1 = 'FIELD_SERVICE'
481: AND hou.org_information_context = 'CS_USER_CONTEXT';
482: */

Line 1478: FROM hr_organization_information hou

1474: CURSOR get_new_context(p_new_org_id number) IS
1475: SELECT org_information2 ,
1476: org_information3 ,
1477: org_information4
1478: FROM hr_organization_information hou
1479: WHERE hou.organization_id = p_new_org_id
1480: AND hou.org_information1 = 'FIELD_SERVICE'
1481: AND hou.org_information_context = 'CS_USER_CONTEXT';
1482: */

Line 4585: FROM HR_ORGANIZATION_INFORMATION

4581:
4582: Begin
4583: SELECT ORG_INFORMATION3, ORG_INFORMATION4
4584: INTO l_VENDOR_ID, l_VENDOR_SITE_ID
4585: FROM HR_ORGANIZATION_INFORMATION
4586: WHERE ORGANIZATION_ID = l_source_organization_id
4587: and org_information_context = 'Customer/Supplier Association';
4588: Exception
4589: When no_data_found then