APPS.PV_ORDER_MGMT_PVT dependencies on PV_PARTNER_PROGRAM_B

Line 786: FROM PV_PARTNER_PROGRAM_B pvpp, PV_PG_ENRL_REQUESTS pver,

782:
783: -- Cursor to get partner program inventoty item id
784: CURSOR c_inventory_item_id IS
785: SELECT /*+ CARDINALITY(erequests 10) */ pvpp.inventory_item_id, pver.enrl_request_id, pver.order_header_id, pver.object_version_number
786: FROM PV_PARTNER_PROGRAM_B pvpp, PV_PG_ENRL_REQUESTS pver,
787: (Select column_value from table (CAST(p_enrl_req_id AS JTF_NUMBER_TABLE))) erequests
788: WHERE pver.enrl_request_id = erequests.column_value
789: and pver.PROGRAM_ID = pvpp.program_id
790: and pver.custom_setup_id in (7004, 7005)

Line 996: FROM PV_PARTNER_PROGRAM_B pvpp

992:
993: -- Cursor to get partner program inventoty item id
994: CURSOR c_inventory_item_id(cv_program_id NUMBER) IS
995: SELECT pvpp.inventory_item_id
996: FROM PV_PARTNER_PROGRAM_B pvpp
997: WHERE program_id = cv_program_id;
998:
999:
1000: BEGIN