APPS.PSB_WS_OPS_PVT dependencies on PSB_WS_DISTRIBUTION_DETAILS

Line 3769: l_distribution_id psb_ws_distribution_details.distribution_id%TYPE ;

3765: l_current_budget_group_id psb_worksheets.budget_group_id%TYPE ;
3766: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
3767: l_parent_budget_group_id psb_worksheets.budget_group_id%TYPE ;
3768: l_parent_worksheet_id psb_worksheets.worksheet_id%TYPE ;
3769: l_distribution_id psb_ws_distribution_details.distribution_id%TYPE ;
3770:
3771: BEGIN
3772: --
3773: SAVEPOINT Add_Worksheet_Line_Pvt ;

Line 4253: l_distribution_id psb_ws_distribution_details.distribution_id%TYPE;

4249: l_current_budget_group_id psb_worksheets.budget_group_id%TYPE ;
4250: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
4251: l_parent_budget_group_id psb_worksheets.budget_group_id%TYPE ;
4252: l_parent_worksheet_id psb_worksheets.worksheet_id%TYPE ;
4253: l_distribution_id psb_ws_distribution_details.distribution_id%TYPE;
4254:
4255: BEGIN
4256: --
4257: SAVEPOINT Add_Worksheet_Pos_Line_Pvt ;

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 6448: -- Delete from psb_ws_distribution_details.

6444: /*For Bug No : 2266309 End*/
6445:
6446: END IF;
6447:
6448: -- Delete from psb_ws_distribution_details.
6449: DELETE psb_ws_distribution_details
6450: WHERE child_worksheet_id = p_worksheet_id ;
6451:
6452: -- Delete from psb_workflow_processes.

Line 6449: DELETE psb_ws_distribution_details

6445:
6446: END IF;
6447:
6448: -- Delete from psb_ws_distribution_details.
6449: DELETE psb_ws_distribution_details
6450: WHERE child_worksheet_id = p_worksheet_id ;
6451:
6452: -- Delete from psb_workflow_processes.
6453: DELETE psb_workflow_processes