APPS.ZPB_DC_DISTRIBUTE dependencies on ZPB_DC_OBJECTS

Line 46: FROM ZPB_DC_OBJECTS

42:
43: CURSOR dist_pending_csr IS
44: SELECT distinct object_user_id,
45: business_area_id
46: FROM ZPB_DC_OBJECTS
47: WHERE status = 'DISTRIBUTION_PENDING'
48: --AND object_user_id = 1009108
49: --AND business_area_id = 22
50: AND object_type in ('W','C');

Line 203: FROM zpb_dc_objects

199: object_id,
200: currency_flag,
201: ac_instance_id,
202: generate_template_task_id
203: FROM zpb_dc_objects
204: WHERE status = 'DISTRIBUTION_PENDING'
205: AND object_type in ('W','C')
206: AND object_user_id = p_user_id
207: AND business_area_id = p_business_area_id;

Line 311: FROM zpb_dc_objects

307: --use the distributors currency
308: IF(l_object_type = 'W' AND l_distributor_user_id <> -100) THEN
309: SELECT view_type
310: INTO l_currency_view
311: FROM zpb_dc_objects
312: WHERE template_id = l_template_id
313: AND object_user_id = l_distributor_user_id
314: AND object_type in ('W','C');
315: END IF;

Line 369: --Update ZPB_DC_OBJECTS with the currency

365: l_command := 'call pa.commit()';
366: zpb_aw.EXECUTE(l_command);
367: zpb_log.WRITE_STATEMENT(l_api_name ,'Data Committed');
368:
369: --Update ZPB_DC_OBJECTS with the currency
370: IF (l_currency_flag = 'Y') THEN
371: UPDATE zpb_dc_objects
372: SET view_type = l_currency_view,
373: -- WHO columns

Line 371: UPDATE zpb_dc_objects

367: zpb_log.WRITE_STATEMENT(l_api_name ,'Data Committed');
368:
369: --Update ZPB_DC_OBJECTS with the currency
370: IF (l_currency_flag = 'Y') THEN
371: UPDATE zpb_dc_objects
372: SET view_type = l_currency_view,
373: -- WHO columns
374: last_update_date = SYSDATE,
375: last_updated_by = fnd_global.user_id,