APPS.AMS_SYNC_CALENDAR_PVT dependencies on QP_LIST_HEADERS_B

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 76: FROM OZF_OFFERS obj, qp_list_headers_b g, jtf_cal_items_b cal

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
77: WHERE (obj.CUSTOM_SETUP_ID = DECODE(x_criteria_rec.CUSTOM_SETUP_ID, NULL, obj.CUSTOM_SETUP_ID, x_criteria_rec.CUSTOM_SETUP_ID)
78: AND obj.QP_LIST_HEADER_ID = cal.source_id
79: AND cal.source_code = 'AMS_OFFR'
80: AND obj.OFFER_TYPE = DECODE(x_criteria_rec.ACTIVITY_TYPE_CODE, NULL, obj.OFFER_TYPE, x_criteria_rec.ACTIVITY_TYPE_CODE)

Line 293: FROM OZF_OFFERS obj, qp_list_headers_b g

289: , obj.CREATION_DATE
290: , obj.LAST_UPDATED_BY
291: , obj.LAST_UPDATE_DATE
292: , obj.LAST_UPDATE_LOGIN
293: FROM OZF_OFFERS obj, qp_list_headers_b g
294: WHERE (obj.CUSTOM_SETUP_ID = DECODE(x_criteria_rec.CUSTOM_SETUP_ID, NULL, obj.CUSTOM_SETUP_ID, x_criteria_rec.CUSTOM_SETUP_ID)
295: AND obj.OFFER_TYPE = DECODE(x_criteria_rec.ACTIVITY_TYPE_CODE, NULL, obj.OFFER_TYPE, x_criteria_rec.ACTIVITY_TYPE_CODE)
296: AND obj.USER_STATUS_ID = DECODE(x_criteria_rec.STATUS_ID, NULL, obj.USER_STATUS_ID, x_criteria_rec.STATUS_ID)
297: AND obj.QP_LIST_HEADER_ID = DECODE(x_criteria_rec.OBJECT_ID, NULL, obj.QP_LIST_HEADER_ID, x_criteria_rec.OBJECT_ID)

Line 597: FROM OZF_OFFERS obj , qp_list_headers_b g, JTF_CAL_ITEMS_B cal

593: , obj.CREATION_DATE
594: , obj.LAST_UPDATED_BY
595: , obj.LAST_UPDATE_DATE
596: , obj.LAST_UPDATE_LOGIN
597: FROM OZF_OFFERS obj , qp_list_headers_b g, JTF_CAL_ITEMS_B cal
598: WHERE (obj.CUSTOM_SETUP_ID = DECODE(x_criteria_rec.CUSTOM_SETUP_ID, NULL, obj.CUSTOM_SETUP_ID, x_criteria_rec.CUSTOM_SETUP_ID)
599: AND cal.source_code = 'AMS_OFFR'
600: AND cal.source_id = obj.QP_LIST_HEADER_ID
601: AND ( cal.start_date <> nvl(g.START_DATE_ACTIVE, obj.CREATION_DATE)