APPS.JTF_MINISITERUNTIME_PVT dependencies on JTF_MSITE_CURRENCIES

Line 157: FROM jtf_msite_currencies c

153: WHERE l.msite_id = l_msite_id;
154:
155: OPEN x_currency_cur FOR SELECT currency_code, bizpartner_prc_listid,
156: registered_prc_listid, walkin_prc_listid, orderable_limit
157: FROM jtf_msite_currencies c
158: WHERE c.msite_id = l_msite_id;
159:
160: l_exclude_flag :=
161: FND_PROFILE.Value_Specific('IBE_USE_CATALOG_EXCLUSIONS',null,null,

Line 473: -- Currency assocation(from jtf_msite_currencies table)

469: || 'MM.msite_id = L.msite_id AND '
470: || l_tmp_str
471: || 'ORDER BY MM.msite_id';
472:
473: -- Currency assocation(from jtf_msite_currencies table)
474: OPEN x_currency_cur FOR 'SELECT MM.msite_id, C.currency_code, '
475: || 'C.bizpartner_prc_listid,C.registered_prc_listid, C.walkin_prc_listid, '
476: || 'C.orderable_limit '
477: || 'FROM jtf_msite_currencies C, jtf_msites_b MM WHERE '

Line 477: || 'FROM jtf_msite_currencies C, jtf_msites_b MM WHERE '

473: -- Currency assocation(from jtf_msite_currencies table)
474: OPEN x_currency_cur FOR 'SELECT MM.msite_id, C.currency_code, '
475: || 'C.bizpartner_prc_listid,C.registered_prc_listid, C.walkin_prc_listid, '
476: || 'C.orderable_limit '
477: || 'FROM jtf_msite_currencies C, jtf_msites_b MM WHERE '
478: || 'MM.msite_id = C.msite_id AND '
479: || l_tmp_str
480: || 'ORDER BY MM.msite_id';
481: