DBA Data[Home] [Help]

APPS.PSB_COMMITMENTS_PVT dependencies on PSB_BUDGET_REVISIONS

Line 329: psb_budget_revisions pbr

325:
326: CURSOR C_Root_Set_Of_Books IS
327: SELECT nvl(pbg.root_set_of_books_id, pbg.set_of_books_id)
328: FROM psb_budget_groups_v pbg,
329: psb_budget_revisions pbr
330: WHERE pbg.budget_group_id = pbr.budget_group_id
331: AND pbr.budget_revision_id = p_budget_revision_id;
332:
333: BEGIN

Line 460: psb_budget_revisions pbr

456:
457: CURSOR C_Root_Set_Of_Books IS
458: SELECT nvl(pbg.root_set_of_books_id, pbg.set_of_books_id)
459: FROM psb_budget_groups_v pbg,
460: psb_budget_revisions pbr
461: WHERE pbg.budget_group_id = pbr.budget_group_id
462: AND pbr.budget_revision_id = p_budget_revision_id;
463:
464: BEGIN

Line 592: psb_budget_revisions pbr

588:
589: CURSOR C_Root_Set_Of_Books IS
590: SELECT nvl(pbg.root_set_of_books_id, pbg.set_of_books_id)
591: FROM psb_budget_groups_v pbg,
592: psb_budget_revisions pbr
593: WHERE pbg.budget_group_id = pbr.budget_group_id
594: AND pbr.budget_revision_id = p_budget_revision_id;
595:
596: BEGIN