APPS.PSB_SUBMIT_WORKSHEET_PVT dependencies on PSB_BUDGET_GROUP_RESP

Line 1039: psb_budget_group_resp resp

1035: FOR l_role_rec IN
1036: (
1037: SELECT wf_role_name
1038: FROM psb_budget_groups bg ,
1039: psb_budget_group_resp resp
1040: WHERE resp.responsibility_type = 'N'
1041: AND bg.budget_group_id = l_budget_group_id
1042: AND bg.budget_group_id = resp.budget_group_id
1043: )

Line 1502: psb_budget_group_resp resp

1498: FOR l_role_rec IN
1499: (
1500: SELECT wf_role_name
1501: FROM psb_budget_groups bg ,
1502: psb_budget_group_resp resp
1503: WHERE resp.responsibility_type = 'N'
1504: AND bg.budget_group_id = l_budget_group_id
1505: AND bg.budget_group_id = resp.budget_group_id
1506: )

Line 1787: l_wf_role_name psb_budget_group_resp.wf_role_name%TYPE ;

1783: l_approval_option VARCHAR2(1) ;
1784: l_review_budget_group_id NUMBER ;
1785: l_review_budget_group_name psb_budget_workflow_rules.name%TYPE ;
1786: l_set_tbl PSB_WS_Ops_Pvt.account_position_set_tbl_type ;
1787: l_wf_role_name psb_budget_group_resp.wf_role_name%TYPE ;
1788: --For Bug#4475288: Modifying width of l_review_group_approver_name from VARCHAR2(80)
1789: l_review_group_approver_name psb_budget_group_resp.wf_role_name%TYPE ;
1790: l_operation_id NUMBER ;
1791: --

Line 1789: l_review_group_approver_name psb_budget_group_resp.wf_role_name%TYPE ;

1785: l_review_budget_group_name psb_budget_workflow_rules.name%TYPE ;
1786: l_set_tbl PSB_WS_Ops_Pvt.account_position_set_tbl_type ;
1787: l_wf_role_name psb_budget_group_resp.wf_role_name%TYPE ;
1788: --For Bug#4475288: Modifying width of l_review_group_approver_name from VARCHAR2(80)
1789: l_review_group_approver_name psb_budget_group_resp.wf_role_name%TYPE ;
1790: l_operation_id NUMBER ;
1791: --
1792: l_count NUMBER ;
1793: l_loop_visited_counter NUMBER ;

Line 2019: psb_budget_group_resp resp

2015:
2016: -- Find approvers for the current review group.
2017: SELECT wf_role_name INTO l_review_group_approver_name
2018: FROM psb_budget_groups bg ,
2019: psb_budget_group_resp resp
2020: WHERE resp.responsibility_type = 'N'
2021: AND bg.budget_group_id = l_review_budget_group_id
2022: AND bg.budget_group_id = resp.budget_group_id
2023: AND ROWNUM < 2 ;

Line 2531: psb_budget_group_resp resp

2527: FOR l_role_rec IN
2528: (
2529: SELECT wf_role_name
2530: FROM psb_budget_groups bg ,
2531: psb_budget_group_resp resp
2532: WHERE bg.budget_group_id = l_parent_budget_group_id
2533: AND resp.responsibility_type = 'N'
2534: AND bg.budget_group_id = resp.budget_group_id
2535: )