DBA Data[Home] [Help]

APPS.PSB_COMMITMENTS_PVT dependencies on PSB_BUDGET_GROUPS_V

Line 66: FROM psb_budget_groups_v pbg,

62: l_cbc_enabled BOOLEAN;
63:
64: CURSOR C_Root_Set_Of_Books IS
65: SELECT nvl(pbg.root_set_of_books_id, pbg.set_of_books_id)
66: FROM psb_budget_groups_v pbg,
67: psb_worksheets pw
68: WHERE pbg.budget_group_id = pw.budget_group_id
69: AND pw.worksheet_id = p_worksheet_id;
70:

Line 196: FROM psb_budget_groups_v pbg,

192: l_cbc_enabled BOOLEAN;
193:
194: CURSOR C_Root_Set_Of_Books IS
195: SELECT nvl(pbg.root_set_of_books_id, pbg.set_of_books_id)
196: FROM psb_budget_groups_v pbg,
197: psb_worksheets pw
198: WHERE pbg.budget_group_id = pw.budget_group_id
199: AND pw.worksheet_id = p_worksheet_id;
200:

Line 328: FROM psb_budget_groups_v pbg,

324: l_cbc_enabled BOOLEAN;
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:

Line 459: FROM psb_budget_groups_v pbg,

455: l_cbc_enabled BOOLEAN;
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:

Line 591: FROM psb_budget_groups_v pbg,

587: l_cbc_enabled BOOLEAN;
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: