APPS.AMS_SYNC_CALENDAR_PVT dependencies on QP_LIST_HEADERS_VL

Line 72: --BugFix 4256877 qp_list_headers_vl to qp_list_headers_b

68: )
69: );
70: l_get_delete_eveo_id_rec c_get_delete_eveo_ids%ROWTYPE;
71:
72: --BugFix 4256877 qp_list_headers_vl to qp_list_headers_b
73:
74: CURSOR c_get_delete_offr_ids (x_criteria_rec cal_criteria_rec) IS
75: SELECT obj.QP_LIST_HEADER_ID
76: FROM OZF_OFFERS obj, qp_list_headers_b g, jtf_cal_items_b cal

Line 925: FROM OZF_OFFERS obj, JTF_CAL_ITEMS_B cal, qp_list_headers_vl g

921:
922: CURSOR c_get_del_offr_items (x_criteria_rec cal_criteria_rec) IS
923: SELECT cal.cal_item_id
924: , cal.object_version_number
925: FROM OZF_OFFERS obj, JTF_CAL_ITEMS_B cal, qp_list_headers_vl g
926: WHERE (obj.CUSTOM_SETUP_ID = DECODE(x_criteria_rec.CUSTOM_SETUP_ID, NULL, obj.CUSTOM_SETUP_ID, x_criteria_rec.CUSTOM_SETUP_ID)
927: AND obj.OFFER_TYPE = DECODE(x_criteria_rec.ACTIVITY_TYPE_CODE, NULL, obj.OFFER_TYPE, x_criteria_rec.ACTIVITY_TYPE_CODE)
928: AND obj.USER_STATUS_ID = DECODE(x_criteria_rec.STATUS_ID, NULL, obj.USER_STATUS_ID, x_criteria_rec.STATUS_ID)
929: AND obj.QP_LIST_HEADER_ID = DECODE(x_criteria_rec.OBJECT_ID, NULL, obj.QP_LIST_HEADER_ID, x_criteria_rec.OBJECT_ID)