DBA Data[Home] [Help]

APPS.IBE_QUOTE_SAVE_PVT dependencies on IBE_MSITE_INFORMATION

Line 6178: FROM ibe_msite_information m, wsh_carrier_ship_methods o, oe_system_parameters_all oesp

6174:
6175: cursor c_get_MiniSiteOrg_ShipMethod(l_msite_id number, l_org_id number,l_ship_mthd varchar2, l_web_enabled varchar2, l_enabled_flag varchar2)
6176: is
6177: SELECT msite_information1
6178: FROM ibe_msite_information m, wsh_carrier_ship_methods o, oe_system_parameters_all oesp
6179: WHERE m.msite_id = l_msite_id
6180: AND m.msite_information_context = l_ship_mthd
6181: AND m.msite_information1 = o.ship_method_code
6182: AND oesp.org_id = l_org_id

Line 6421: FROM ibe_msite_information a, fnd_lookup_values b

6417:
6418: cursor c_check_CC_enabled(l_msite_id number)
6419: is
6420: SELECT msite_information1
6421: FROM ibe_msite_information a, fnd_lookup_values b
6422: WHERE a.msite_id = l_msite_id
6423: AND a.msite_information1 = b.lookup_code
6424: AND a.msite_information1 = 'CREDIT_CARD'
6425: AND b.LOOKUP_TYPE = 'IBE_PAYMENT_TYPE'

Line 6433: FROM ibe_msite_information a, fnd_lookup_values b

6429:
6430: cursor c_get_next_payment_type(l_msite_id number)
6431: is
6432: SELECT msite_information1
6433: FROM ibe_msite_information a, fnd_lookup_values b
6434: WHERE a.msite_id = l_msite_id
6435: AND a.msite_information1 = b.lookup_code
6436: AND a.msite_information1 <> 'CREDIT_CARD'
6437: AND b.LOOKUP_TYPE = 'IBE_PAYMENT_TYPE'