APPS.PSB_WORKFLOW_PVT dependencies on PSB_BUDGET_GROUPS

Line 180: FROM psb_ws_distribution_rule_lines a, psb_budget_groups b

176: SELECT a.budget_group_id ,b.short_name short_name,
177: NVL( distribute_all_level_flag, 'N') distribute_all_level_flag,
178: NVL( download_flag, 'N') download_flag,
179: NVL( download_all_level_flag, 'N') download_all_level_flag
180: FROM psb_ws_distribution_rule_lines a, psb_budget_groups b
181: WHERE distribution_rule_id = l_distribution_rule_id
182: AND a.budget_group_id = b.budget_group_id
183: )
184: LOOP

Line 255: FROM psb_budget_groups

251: --
252: FOR l_child_bgs_rec IN
253: (
254: SELECT budget_group_id, short_name short_name
255: FROM psb_budget_groups
256: WHERE budget_group_type = 'R'
257: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp
258: AND ((effective_end_date IS NULL)
259: OR

Line 488: FROM psb_budget_groups bg ,

484: --
485: -- Find budget_group users information.
486: --
487: SELECT min(wf_role_name) INTO l_wf_role_name
488: FROM psb_budget_groups bg ,
489: psb_budget_group_resp resp
490: WHERE bg.budget_group_id = l_budget_group_id
491: AND resp.responsibility_type = 'N'
492: AND bg.budget_group_id = resp.budget_group_id ;

Line 610: FROM psb_budget_groups

606: l_bg_short_name VARCHAR2(20);
607: --To find the BG short name
608: CURSOR c_bg_name IS
609: SELECT short_name
610: FROM psb_budget_groups
611: WHERE budget_group_id = p_budget_group_id;
612: /*For Bug No : 2239422 End*/
613:
614: --

Line 643: FROM psb_budget_groups bg ,

639:
640: -- Find the approver role name for the budget group.
641: CURSOR l_role_csr IS
642: SELECT wf_role_name, budget_group_resp_id
643: FROM psb_budget_groups bg ,
644: psb_budget_group_resp resp
645: WHERE bg.budget_group_id = p_budget_group_id
646: AND resp.responsibility_type = 'N'
647: AND bg.budget_group_id = resp.budget_group_id;

Line 1195: FROM psb_ws_distribution_rule_lines a, psb_budget_groups b

1191: SELECT a.budget_group_id ,b.short_name short_name,
1192: NVL( distribute_all_level_flag, 'N') distribute_all_level_flag,
1193: NVL( download_flag, 'N') download_flag,
1194: NVL( download_all_level_flag, 'N') download_all_level_flag
1195: FROM psb_ws_distribution_rule_lines a, psb_budget_groups b
1196: WHERE distribution_rule_id = l_distribution_rule_id
1197: AND a.budget_group_id = b.budget_group_id
1198: )
1199: LOOP

Line 1235: FROM psb_budget_groups

1231: --
1232: FOR l_child_bgs_rec IN
1233: (
1234: SELECT budget_group_id, short_name short_name
1235: FROM psb_budget_groups
1236: WHERE budget_group_type = 'R'
1237: START WITH budget_group_id = l_budget_groups_rec.budget_group_id
1238: CONNECT BY PRIOR budget_group_id = parent_budget_group_id
1239: )

Line 1333: FROM psb_budget_groups

1329: l_bg_short_name VARCHAR2(20);
1330: --To find the BG short name
1331: CURSOR c_bg_name IS
1332: SELECT short_name
1333: FROM psb_budget_groups
1334: WHERE budget_group_id = p_budget_group_id;
1335: /*For Bug No : 2239422 End*/
1336:
1337: --

Line 1368: FROM psb_budget_groups bg ,

1364:
1365: -- Find the approver role name for the budget group.
1366: CURSOR l_role_csr IS
1367: SELECT wf_role_name, budget_group_resp_id
1368: FROM psb_budget_groups bg ,
1369: psb_budget_group_resp resp
1370: WHERE bg.budget_group_id = p_budget_group_id
1371: AND resp.responsibility_type = 'N'
1372: AND bg.budget_group_id = resp.budget_group_id;

Line 1691: FROM psb_budget_groups bg ,

1687: --
1688: -- Find budget_group users information.
1689: --
1690: SELECT min(wf_role_name) INTO l_wf_role_name
1691: FROM psb_budget_groups bg ,
1692: psb_budget_group_resp resp
1693: WHERE bg.budget_group_id = l_budget_group_id
1694: AND resp.responsibility_type = 'N'
1695: AND bg.budget_group_id = resp.budget_group_id ;