DBA Data[Home] [Help]

APPS.OE_BULK_TAX_UTIL dependencies on FND_CURRENCIES

Line 454: l_minimum_accountable_unit fnd_currencies.minimum_accountable_unit%type;

450: l_msg_data VARCHAR2(1000);
451: I INTEGER;
452: J INTEGER;
453: l_call_tax VARCHAR2(1) := 'N';
454: l_minimum_accountable_unit fnd_currencies.minimum_accountable_unit%type;
455: l_precision fnd_currencies.precision%type;
456: l_ship_from_location_id NUMBER;
457: l_commitment_id oe_order_lines.commitment_id%type;
458: l_currency_code VARCHAR2(30);

Line 455: l_precision fnd_currencies.precision%type;

451: I INTEGER;
452: J INTEGER;
453: l_call_tax VARCHAR2(1) := 'N';
454: l_minimum_accountable_unit fnd_currencies.minimum_accountable_unit%type;
455: l_precision fnd_currencies.precision%type;
456: l_ship_from_location_id NUMBER;
457: l_commitment_id oe_order_lines.commitment_id%type;
458: l_currency_code VARCHAR2(30);
459: l_inventory_org_id NUMBER;

Line 763: FROM fnd_currencies c

759: SELECT c.minimum_accountable_unit,
760: c.precision
761: INTO l_minimum_accountable_unit,
762: l_precision
763: FROM fnd_currencies c
764: WHERE c.currency_code = l_currency_code;
765: OPEN get_internal_loc(OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index));
766: FETCH get_internal_loc INTO l_internal_org_location_id;
767: CLOSE get_internal_loc;

Line 929: FROM fnd_currencies c

925: SELECT c.minimum_accountable_unit,
926: c.precision
927: INTO l_minimum_accountable_unit,
928: l_precision
929: FROM fnd_currencies c
930: WHERE c.currency_code = l_currency_code;
931: OPEN get_internal_loc(OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index));
932: FETCH get_internal_loc INTO l_internal_org_location_id;
933: CLOSE get_internal_loc;

Line 1082: FROM fnd_currencies c

1078: SELECT c.minimum_accountable_unit,
1079: c.precision
1080: INTO l_minimum_accountable_unit,
1081: l_precision
1082: FROM fnd_currencies c
1083: WHERE c.currency_code = l_currency_code;
1084: OPEN get_internal_loc(OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index));
1085: FETCH get_internal_loc INTO l_internal_org_location_id;
1086: CLOSE get_internal_loc;