APPS.IBE_QUOTE_SAVE_PVT dependencies on FND_LOOKUP_VALUES

Line 3631: from fnd_lookup_values_vl

3627: where status_code = p_status_code;
3628:
3629: Cursor c_get_lkp_meaning(lkp_code varchar2) is
3630: select lookup_code, meaning
3631: from fnd_lookup_values_vl
3632: where lookup_code = lkp_code
3633: and lookup_type = 'IBE_SALES_ASSIST_REASONS_LK';
3634:
3635:

Line 3654: l_reason_code_meaning fnd_lookup_values_vl.meaning%type;

3650: lx_msg_count NUMBER;
3651: lx_msg_data VARCHAR2(2000);
3652: lx_last_update_date DATE;
3653: l_check_resource_id NUMBER;
3654: l_reason_code_meaning fnd_lookup_values_vl.meaning%type;
3655: lx_jtf_note_id NUMBER;
3656: l_quote_status aso_quote_statuses_vl.status_code%type;
3657:
3658: rec_get_SR_user_id c_get_SR_user_id%rowtype;

Line 6528: FROM ibe_msite_information a, fnd_lookup_values b

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'

Line 6540: FROM ibe_msite_information a, fnd_lookup_values b

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'