eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSB_SUBMIT_WORKSHEET_PVT dependencies on PSB_BUDGET_WORKFLOW_RULES

Line 1697: psb_budget_workflow_rules rules ,

1693: INSERT INTO psb_wf_review_groups
1694: ( item_key, budget_workflow_rule_id, sequence )
1695: SELECT itemkey, rules.budget_workflow_rule_id, ROWNUM
1696: FROM psb_budget_group_categories cats ,
1697: psb_budget_workflow_rules rules ,
1698: psb_budget_groups bg
1699: WHERE cats.budget_group_id = l_budget_group_id
1700: AND rules.budget_group_id = l_root_budget_group_id
1701: AND rules.stage_id = cats.stage_id

Line 1785: l_review_budget_group_name psb_budget_workflow_rules.name%TYPE ;

1781: l_budget_workflow_rule_id NUMBER ;
1782: l_account_or_position_type VARCHAR2(1) ;
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 ;

Line 1887: psb_budget_workflow_rules rules

1883: l_budget_workflow_rule_id ,
1884: l_approval_option ,
1885: l_review_budget_group_id
1886: FROM psb_wf_review_groups wrg ,
1887: psb_budget_workflow_rules rules
1888: WHERE item_key = itemkey
1889: AND sequence = l_loop_visited_counter
1890: AND rules.budget_workflow_rule_id = wrg.budget_workflow_rule_id ;
1891:

Line 1929: FROM psb_budget_workflow_rules

1925: --
1926:
1927: -- Check whether the budget workflow rule is for 'New Positions'.
1928: SELECT account_or_position_type INTO l_account_or_position_type
1929: FROM psb_budget_workflow_rules
1930: WHERE budget_workflow_rule_id = l_budget_workflow_rule_id ;
1931:
1932: IF l_account_or_position_type IN ( 'A', 'P') THEN
1933:

Line 1941: FROM psb_budget_workflow_rules rules ,

1937: FOR l_set_rec IN
1938: (
1939: SELECT account_position_set_id,
1940: account_or_position_type
1941: FROM psb_budget_workflow_rules rules ,
1942: psb_set_relations relations
1943: WHERE rules.budget_workflow_rule_id = l_budget_workflow_rule_id
1944: AND relations.budget_workflow_rule_id = rules.budget_workflow_rule_id
1945: )

Line 2167: l_approval_option psb_budget_workflow_rules.approval_option%TYPE ;

2163: result OUT NOCOPY VARCHAR2
2164: )
2165: IS
2166: --
2167: l_approval_option psb_budget_workflow_rules.approval_option%TYPE ;
2168: --
2169: BEGIN
2170: --
2171: IF ( funcmode = 'RUN' ) THEN

Line 2850: psb_budget_workflow_rules rules,

2846: SELECT 'Exists' INTO l_exists FROM dual
2847: WHERE EXISTS
2848: (SELECT 1
2849: FROM psb_budget_group_categories cats,
2850: psb_budget_workflow_rules rules,
2851: psb_budget_groups bg,
2852: psb_set_relations relations,
2853: psb_budget_accounts ba
2854: WHERE cats.budget_group_id = l_budget_group_id

Line 2899: psb_budget_workflow_rules rules,

2895: SELECT 'Exists' INTO l_exists FROM dual
2896: WHERE EXISTS
2897: (SELECT 1
2898: FROM psb_budget_group_categories cats,
2899: psb_budget_workflow_rules rules,
2900: psb_budget_groups bg,
2901: psb_set_relations relations,
2902: psb_budget_positions bp
2903: WHERE cats.budget_group_id = l_budget_group_id

Line 2941: PSB_BUDGET_WORKFLOW_RULES rules,

2937: FROM DUAL
2938: WHERE EXISTS
2939: (SELECT 1
2940: FROM PSB_BUDGET_GROUP_CATEGORIES cats,
2941: PSB_BUDGET_WORKFLOW_RULES rules,
2942: PSB_BUDGET_GROUPS bgrp
2943: WHERE cats.budget_group_id = l_budget_group_id
2944: AND rules.stage_id = cats.stage_id
2945: AND rules.budget_group_id = l_root_budget_group_id