DBA Data[Home] [Help]

APPS.PV_PRICE_PVT dependencies on PV_PARTNER_PROGRAM_B

Line 143: FROM PV_PARTNER_PROGRAM_B pvpp, PV_PG_ENRL_REQUESTS pver,

139:
140: -- Cursor to get partner program inventoty item id
141: CURSOR c_inventory_item_id IS
142: SELECT /*+ CARDINALITY(erequests 10) */ pvpp.inventory_item_id, pver.enrl_request_id, pver.object_version_number
143: FROM PV_PARTNER_PROGRAM_B pvpp, PV_PG_ENRL_REQUESTS pver,
144: (Select column_value from table (CAST(p_enrl_req_id AS JTF_NUMBER_TABLE))) erequests
145: WHERE pver.enrl_request_id = erequests.column_value
146: and pver.PROGRAM_ID = pvpp.program_id
147: and pver.custom_setup_id in (7004, 7005)