[Home] [Help]
6278:
6279: 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)
6280: is
6281: SELECT msite_information1
6282: FROM ibe_msite_information m, wsh_carrier_ship_methods o, oe_system_parameters_all oesp
6283: WHERE m.msite_id = l_msite_id
6284: AND m.msite_information_context = l_ship_mthd
6285: AND m.msite_information1 = o.ship_method_code
6286: AND oesp.org_id = l_org_id
6524:
6525: cursor c_check_CC_enabled(l_msite_id number)
6526: is
6527: SELECT msite_information1
6528: FROM ibe_msite_information a, fnd_lookup_values b
6529: WHERE a.msite_id = l_msite_id
6530: AND a.msite_information1 = b.lookup_code
6531: AND a.msite_information1 = 'CREDIT_CARD'
6532: AND b.LOOKUP_TYPE = 'IBE_PAYMENT_TYPE'
6536:
6537: cursor c_get_next_payment_type(l_msite_id number)
6538: is
6539: SELECT msite_information1
6540: FROM ibe_msite_information a, fnd_lookup_values b
6541: WHERE a.msite_id = l_msite_id
6542: AND a.msite_information1 = b.lookup_code
6543: AND a.msite_information1 <> 'CREDIT_CARD'
6544: AND b.LOOKUP_TYPE = 'IBE_PAYMENT_TYPE'