APPS.PSB_GL_INTERFACE_PVT dependencies on PSB_BUDGET_REVISIONS

Line 579: FROM PSB_BUDGET_REVISIONS a,

575: b.enable_average_balances_flag,
576: b.period_set_name,
577: b.latest_opened_period_name,
578: b.require_budget_journals_flag
579: FROM PSB_BUDGET_REVISIONS a,
580: GL_SETS_OF_BOOKS b,
581: PSB_BUDGET_GROUPS_V c
582: WHERE b.set_of_books_id = NVL(c.set_of_books_id,c.root_set_of_books_id)
583: AND a.budget_group_id = c.budget_group_id

Line 1581: FROM psb_budget_revisions

1577:
1578: CURSOR c_rev_type
1579: IS
1580: SELECT budget_revision_type
1581: FROM psb_budget_revisions
1582: WHERE budget_revision_id = p_source_id;
1583:
1584: CURSOR c_ws
1585: IS

Line 1665: PSB_BUDGET_REVISIONS_PVT.Create_Base_Budget_Revision

1661: END;
1662: END IF;
1663:
1664: -- Initial posting of budget to revisions
1665: PSB_BUDGET_REVISIONS_PVT.Create_Base_Budget_Revision
1666: (p_api_version => 1.0,
1667: p_return_status => l_return_status,
1668: p_msg_count => p_msg_count,
1669: p_msg_data => p_msg_data,

Line 3120: PSB_BUDGET_REVISIONS_PVT.Create_Base_Budget_Revision

3116: END IF;
3117: END;
3118: END IF;
3119:
3120: PSB_BUDGET_REVISIONS_PVT.Create_Base_Budget_Revision
3121: (p_api_version => 1.0,
3122: p_return_status => l_return_status,
3123: p_msg_count => l_msg_count,
3124: p_msg_data => l_msg_data,

Line 3184: FROM PSB_BUDGET_REVISIONS

3180:
3181: CURSOR c_revision
3182: IS
3183: SELECT permanent_revision
3184: FROM PSB_BUDGET_REVISIONS
3185: WHERE budget_revision_id = p_source_id;
3186:
3187: BEGIN
3188: /* Bug 3029168 Start */

Line 3407: FROM psb_budget_revisions br,

3403: bra.revision_amount * -1.0
3404: )
3405: ) cr_amount,
3406: budget_balance x_amount
3407: FROM psb_budget_revisions br,
3408: psb_budget_revision_accounts bra,
3409: psb_budget_revision_lines brl,
3410: gl_period_statuses gps,
3411: psb_gl_budgets pgb

Line 3752: FROM psb_budget_revisions

3748:
3749: /* Bug 3029168 Start */
3750: SELECT currency_code,budget_group_id,gl_budget_set_id
3751: INTO l_currency_code,l_budget_group_id,l_gl_budget_set_id
3752: FROM psb_budget_revisions
3753: WHERE budget_revision_id = p_budget_revision_id;
3754: /* Bug 3029168 Start */
3755:
3756: IF l_currency_code = 'STAT' THEN

Line 4575: PSB_BUDGET_REVISIONS_PVT.Create_Base_Budget_Revision

4571: /*FOR Bug No : 2221409 Start*/
4572: --commented the following procedure as the same has to be
4573: --invoked after uploading all the lines INTO SLA tables
4574: /*
4575: PSB_BUDGET_REVISIONS_PVT.Create_Base_Budget_Revision
4576: (p_api_version => 1.0,
4577: p_return_status => l_return_status,
4578: p_msg_count => l_msg_count,
4579: p_msg_data => l_msg_data,

Line 4610: PSB_BUDGET_REVISIONS_PVT.Create_Base_Budget_Revision

4606: END IF; -- no validation error found
4607:
4608: /*FOR Bug No : 2221409 Start*/
4609:
4610: PSB_BUDGET_REVISIONS_PVT.Create_Base_Budget_Revision
4611: (p_api_version => 1.0,
4612: p_return_status => l_return_status,
4613: p_msg_count => l_msg_count,
4614: p_msg_data => l_msg_data,