DBA Data[Home] [Help]

APPS.IBE_QUOTE_SAVE_PVT dependencies on FND_LOOKUP_VALUES

Line 3612: from fnd_lookup_values_vl

3608: where status_code = p_status_code;
3609:
3610: Cursor c_get_lkp_meaning(lkp_code varchar2) is
3611: select lookup_code, meaning
3612: from fnd_lookup_values_vl
3613: where lookup_code = lkp_code
3614: and lookup_type = 'IBE_SALES_ASSIST_REASONS_LK';
3615:
3616:

Line 3635: l_reason_code_meaning fnd_lookup_values_vl.meaning%type;

3631: lx_msg_count NUMBER;
3632: lx_msg_data VARCHAR2(2000);
3633: lx_last_update_date DATE;
3634: l_check_resource_id NUMBER;
3635: l_reason_code_meaning fnd_lookup_values_vl.meaning%type;
3636: lx_jtf_note_id NUMBER;
3637: l_quote_status aso_quote_statuses_vl.status_code%type;
3638:
3639: rec_get_SR_user_id c_get_SR_user_id%rowtype;

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'