APPS.PSB_SUBMIT_REVISION_PVT dependencies on PSB_BUDGET_GROUPS

Line 14: g_budgetgroup_name psb_budget_groups.name%TYPE ;

10: -- CALLBACK procedure related global information.
11: --
12:
13: g_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;
14: g_budgetgroup_name psb_budget_groups.name%TYPE ;
15: g_requestor_name VARCHAR2(100);
16: g_itemtype VARCHAR2(2000) ;
17: g_itemkey VARCHAR2(2000) ;
18:

Line 272: l_budget_group_name psb_budget_groups.name%TYPE ;

268: )
269: IS
270: --
271: l_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;
272: l_budget_group_name psb_budget_groups.name%TYPE ;
273: l_submitter_name VARCHAR2(80);
274: --
275: l_orig_system VARCHAR2(8) ;
276: l_submitter_id NUMBER ;

Line 783: FROM psb_budget_groups bg ,

779: --
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

Line 1704: psb_budget_groups bg

1700: SELECT nvl(bg.parent_budget_group_id,bg.budget_group_id)
1701: INTO
1702: l_parent_budget_group_id
1703: FROM psb_budget_revisions br,
1704: psb_budget_groups bg
1705: WHERE br.budget_revision_id = l_budget_revision_id
1706: AND br.budget_group_id = bg.budget_group_id ;
1707:
1708:

Line 1713: FROM psb_budget_groups bg ,

1709:
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

Line 1893: psb_budget_groups bg

1889: SELECT nvl(bg.parent_budget_group_id,bg.budget_group_id)
1890: INTO
1891: l_parent_budget_group_id
1892: FROM psb_budget_revisions br,
1893: psb_budget_groups bg
1894: WHERE br.budget_revision_id = l_budget_revision_id
1895: AND br.budget_group_id = bg.budget_group_id ;
1896:
1897:

Line 1905: (select budget_group_id from psb_budget_groups bg

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)
1908: AND resp.responsibility_type = 'N';
1909:

Line 2007: psb_budget_groups bg

2003: -- Modified the query for bug 3394080
2004: SELECT nvl(bg.parent_budget_group_id,bg.budget_group_id)
2005: INTO l_parent_budget_group_id
2006: FROM psb_budget_revisions br,
2007: psb_budget_groups bg
2008: WHERE br.budget_revision_id = l_budget_revision_id
2009: AND br.budget_group_id = bg.budget_group_id;
2010:
2011:

Line 2025: FROM psb_budget_groups

2021: FROM psb_budget_group_resp resp,
2022: wf_roles wfr,
2023: ( SELECT level bglevel,
2024: budget_group_id
2025: FROM psb_budget_groups
2026: START WITH budget_group_id = l_parent_budget_group_id CONNECT BY PRIOR parent_budget_group_id = budget_group_id
2027: ) bg
2028: WHERE bg.budget_group_id = resp.budget_group_id
2029: AND resp.responsibility_type = 'N'

Line 2489: l_budget_group_name psb_budget_groups.name%TYPE ;

2485: )
2486: IS
2487: --
2488: l_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;
2489: l_budget_group_name psb_budget_groups.name%TYPE ;
2490: l_recipient_name VARCHAR2(2000);
2491: l_user_name VARCHAR2(100);
2492: --
2493: BEGIN