APPS.PSB_WORKFLOW_PVT dependencies on PSB_WS_DISTRIBUTION_DETAILS

Line 628: FROM psb_ws_distribution_details details, psb_ws_distributions distr

624:
625: /*
626: CURSOR l_child_worksheet_csr IS
627: SELECT child_worksheet_id
628: FROM psb_ws_distribution_details details, psb_ws_distributions distr
629: -- Bug No 2297742 Start
630: -- WHERE distr.worksheet_id = p_worksheet_id
631: WHERE distr.worksheet_id = details.worksheet_id
632: AND distr.distribution_id = p_distribution_id

Line 756: -- Update psb_ws_distribution_details table.

752:
753: /*---2. DISTRIBUTION -------------------------------------------*/
754:
755: --
756: -- Update psb_ws_distribution_details table.
757: --
758: OPEN l_role_csr ;
759: FETCH l_role_csr INTO l_dist_wf_role_name, l_budget_group_resp_id ;
760:

Line 783: INSERT INTO psb_ws_distribution_details

779: END IF;
780: CLOSE l_role_csr ;
781:
782:
783: INSERT INTO psb_ws_distribution_details
784: (
785: distribution_id ,
786: worksheet_id ,
787: global_worksheet_id ,

Line 1351: FROM psb_ws_distribution_details details, psb_ws_distributions distr

1347: /*
1348: -- To find whether a budget revision been created for the budget group.
1349: CURSOR l_child_budget_rev_csr IS
1350: SELECT child_worksheet_id
1351: FROM psb_ws_distribution_details details, psb_ws_distributions distr
1352: WHERE distr.worksheet_id = p_budget_revision_id
1353: AND distr.distribution_id = p_distribution_id
1354: AND distr.distribution_option_flag = 'R'
1355: AND global_worksheet_id = p_global_budget_revision_id

Line 1489: -- Update psb_ws_distribution_details table.

1485:
1486: /*---2. DISTRIBUTION -------------------------------------------*/
1487:
1488: --
1489: -- Update psb_ws_distribution_details table.
1490: --
1491: OPEN l_role_csr ;
1492: FETCH l_role_csr INTO l_dist_wf_role_name, l_budget_group_resp_id ;
1493:

Line 1516: INSERT INTO psb_ws_distribution_details

1512: END IF;
1513: CLOSE l_role_csr ;
1514:
1515:
1516: INSERT INTO psb_ws_distribution_details
1517: (
1518: distribution_id ,
1519: worksheet_id ,
1520: global_worksheet_id ,