APPS.CSP_PARTS_ORDER dependencies on PO_SYSTEM_PARAMETERS

Line 63: po_system_parameters psp

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'
67: AND msi.organization_id = hoi.organization_id

Line 79: po_system_parameters psp

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;
83:

Line 1268: FROM PO_SYSTEM_PARAMETERS_ALL psp,

1264: SELECT psp.line_type_id,
1265: plt.order_type_lookup_code,
1266: plt.purchase_basis,
1267: plt.matching_basis
1268: FROM PO_SYSTEM_PARAMETERS_ALL psp,
1269: PO_LINE_TYPES plt
1270: WHERE psp.org_id = l_org_id
1271: AND plt.line_type_id = psp.line_type_id;
1272:

Line 2259: FROM PO_SYSTEM_PARAMETERS_ALL

2255:
2256: if l_is_valid_order_type <> 1 then
2257: SELECT ORDER_TYPE_ID
2258: INTO l_header_rec.order_type_id
2259: FROM PO_SYSTEM_PARAMETERS_ALL
2260: WHERE ORG_ID = l_source_operating_unit;
2261: end if;
2262:
2263: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then