735: 'PARTY_RELATIONSHIP', bizpartner_prc_listid,
736: 'GUEST', walkin_prc_listid) price_list_id,
737: msite_id,
738: currency_code
739: FROM ibe_msite_currencies
740: WHERE decode (p_party_type, 'PERSON',registered_prc_listid,
741: 'PARTY_RELATIONSHIP', bizpartner_prc_listid,
742: 'GUEST', walkin_prc_listid)
743: IN
743: IN
744: (SELECT decode (p_party_type, 'PERSON',registered_prc_listid,
745: 'PARTY_RELATIONSHIP', bizpartner_prc_listid,
746: 'GUEST', walkin_prc_listid) price_list_id
747: FROM ibe_msite_currencies
748: GROUP BY decode (p_party_type, 'PERSON',registered_prc_listid,
749: 'PARTY_RELATIONSHIP', bizpartner_prc_listid,
750: 'GUEST', walkin_prc_listid)
751: HAVING count(*) = 1 );