DBA Data[Home] [Help]

APPS.PSB_WS_OPS_PVT dependencies on PSB_WS_DISTRIBUTIONS

Line 5220: FROM psb_ws_distribution_details details, psb_ws_distributions distr

5216:
5217: /*
5218: SELECT DISTINCT child_worksheet_id
5219: INTO p_worksheet_id_OUT
5220: FROM psb_ws_distribution_details details, psb_ws_distributions distr
5221: WHERE distr.worksheet_id = details.worksheet_id
5222: -- Bug No 2297742 Start
5223: -- AND distr.distribution_option_flag = 'W'
5224: AND nvl(distr.distribution_option_flag, 'W') = 'W'

Line 5567: FROM psb_ws_distribution_details details, psb_ws_distributions distr

5563:
5564: /*
5565: SELECT child_worksheet_id
5566: INTO l_child_worksheet_id
5567: FROM psb_ws_distribution_details details, psb_ws_distributions distr
5568: WHERE distr.worksheet_id = details.worksheet_id
5569: -- Bug No 2297742 Start
5570: -- AND distr.distribution_option_flag = 'W'
5571: AND nvl(distr.distribution_option_flag, 'W') = 'W'

Line 6456: -- Delete from psb_ws_distributions.

6452: -- Delete from psb_workflow_processes.
6453: DELETE psb_workflow_processes
6454: WHERE worksheet_id = p_worksheet_id ;
6455:
6456: -- Delete from psb_ws_distributions.
6457: DELETE psb_ws_distributions
6458: WHERE worksheet_id = p_worksheet_id ;
6459:
6460: -- Delete from psb_ws_submit_service_packages.

Line 6457: DELETE psb_ws_distributions

6453: DELETE psb_workflow_processes
6454: WHERE worksheet_id = p_worksheet_id ;
6455:
6456: -- Delete from psb_ws_distributions.
6457: DELETE psb_ws_distributions
6458: WHERE worksheet_id = p_worksheet_id ;
6459:
6460: -- Delete from psb_ws_submit_service_packages.
6461: DELETE psb_ws_submit_service_packages