APPS.PSB_SUBMIT_REVISION_PVT dependencies on PSB_BUDGET_GROUP_RESP

Line 784: psb_budget_group_resp resp

780: FOR l_role_rec IN
781: (
782: SELECT wf_role_name
783: FROM psb_budget_groups bg ,
784: psb_budget_group_resp resp
785: WHERE resp.responsibility_type = 'N'
786: AND bg.budget_group_id = l_budget_group_id
787: AND bg.budget_group_id = resp.budget_group_id
788: )

Line 1118: l_approver_name psb_budget_group_resp.wf_role_name%TYPE;

1114: IS
1115: --
1116: l_override_approver psb_budget_revisions.approval_override_by%TYPE;
1117: -- For Bug 4475288: Changed l_approver_name length.
1118: l_approver_name psb_budget_group_resp.wf_role_name%TYPE;
1119: l_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;
1120: l_notification_group_id NUMBER ;
1121: -- Added the following variable for bug 3394080
1122: -- For Bug 4475288: Changed l_approver_display_name length.

Line 1714: psb_budget_group_resp resp

1710: FOR l_role_rec IN
1711: (
1712: SELECT wf_role_name
1713: FROM psb_budget_groups bg ,
1714: psb_budget_group_resp resp
1715: WHERE bg.budget_group_id = l_parent_budget_group_id
1716: AND resp.responsibility_type = 'N'
1717: AND bg.budget_group_id = resp.budget_group_id
1718: )

Line 1903: FROM psb_budget_group_resp resp

1899: g_num_approvers := 0;
1900:
1901: SELECT count(*)
1902: INTO g_num_approvers
1903: FROM psb_budget_group_resp resp
1904: WHERE resp.budget_group_id in
1905: (select budget_group_id from psb_budget_groups bg
1906: start with bg.budget_group_id = l_parent_budget_group_id
1907: connect by prior bg.parent_budget_group_id = bg.budget_group_id)

Line 2021: FROM psb_budget_group_resp resp,

2017: resp.budget_group_resp_id ,
2018: resp.wf_role_name ,
2019: wfr.name name ,
2020: wfr.display_name display_name
2021: FROM psb_budget_group_resp resp,
2022: wf_roles wfr,
2023: ( SELECT level bglevel,
2024: budget_group_id
2025: FROM psb_budget_groups