APPS.OZF_SD_BATCH_PUB dependencies on OZF_SD_BATCH_LINES_ALL

Line 81: FROM ozf_sd_batch_lines_all

77: END IF;
78:
79: SELECT COUNT(1)
80: INTO l_cnt_line
81: FROM ozf_sd_batch_lines_all
82: WHERE batch_id = p_batch_id
83: AND purge_flag <> 'Y'
84: AND transmit_flag = 'Y';
85:

Line 112: FROM ozf_sd_batch_lines_all

108: last_update_date = SYSDATE,
109: last_updated_by = NVL(FND_GLOBAL.user_id,-1)
110: WHERE batch_id = p_batch_id
111: AND batch_line_id IN ( SELECT batch_line_id
112: FROM ozf_sd_batch_lines_all
113: WHERE batch_id = p_batch_id
114: AND purge_flag <> 'Y'
115: AND transmit_flag = 'Y' );
116: END IF;

Line 118: UPDATE ozf_sd_batch_lines_all

114: AND purge_flag <> 'Y'
115: AND transmit_flag = 'Y' );
116: END IF;
117:
118: UPDATE ozf_sd_batch_lines_all
119: SET status_code = 'SUBMITTED',
120: object_version_number = object_version_number + 1,
121: transmit_flag = 'N',
122: process_feed_flag = 'Y',