DBA Data[Home] [Help]

APPS.AMS_EVENTOFFER_PVT dependencies on QP_PRICE_LISTS_V

Line 1596: FROM ams_event_offers_all_b evo, qp_price_lists_v qph

1592: and off.event_offer_id = p_evo_rec.event_offer_id;
1593:
1594: CURSOR c_pricelist_header_id(curr_code IN VARCHAR2) IS
1595: SELECT distinct(pricelist_header_id)
1596: FROM ams_event_offers_all_b evo, qp_price_lists_v qph
1597: WHERE evo.pricelist_header_id = qph.price_list_id
1598: AND qph.currency_code = curr_code;
1599:
1600: CURSOR get_res_id(l_user_id IN NUMBER) IS

Line 6871: FROM ams_event_offers_all_b evo, qp_price_lists_v qph

6867:
6868:
6869: CURSOR c_pricelist_header_id(curr_code IN VARCHAR2) IS
6870: SELECT distinct(pricelist_header_id)
6871: FROM ams_event_offers_all_b evo, qp_price_lists_v qph
6872: WHERE evo.pricelist_header_id = qph.price_list_id
6873: AND qph.currency_code = curr_code;
6874:
6875: BEGIN