APPS.PSB_GL_BUDGET_SET_PVT dependencies on PSB_GL_BUDGETS

Line 546: -- Deleting dependent detail records from psb_gl_budgets.

542: p_return_status := FND_API.G_RET_STS_SUCCESS ;
543: --
544:
545: --
546: -- Deleting dependent detail records from psb_gl_budgets.
547: -- ( To maintain ISOLATED master-detail form relation also. )
548: --
549:
550: SELECT gl_budget_set_id INTO l_gl_budget_set_id

Line 560: FROM psb_gl_budgets

556: --
557: FOR l_budget_rec IN
558: (
559: SELECT ROWID
560: FROM psb_gl_budgets
561: WHERE gl_budget_set_id = l_gl_budget_set_id
562: )
563: LOOP
564: --

Line 808: FROM psb_gl_budgets_v

804: gl_budget_name ,
805: start_date ,
806: end_date ,
807: dual_posting_type
808: FROM psb_gl_budgets_v
809: WHERE gl_budget_set_id = p_gl_budget_set_id
810: )
811: LOOP
812:

Line 842: FROM psb_gl_budgets_v gb ,

838:
839: FOR l_dup_gl_budget_id IN
840: (
841: SELECT gb.gl_budget_name
842: FROM psb_gl_budgets_v gb ,
843: psb_set_relations rel ,
844: psb_budget_accounts pba
845: WHERE gb.gl_budget_set_id = p_gl_budget_set_id
846: AND gb.gl_budget_id <> l_gl_budget_rec.gl_budget_id