APPS.PSB_GL_BUDGET_SET_PVT dependencies on PSB_SET_RELATIONS

Line 694: -- Checking the Psb_set_relations table for references.

690: --
691: p_return_status := FND_API.G_RET_STS_SUCCESS ;
692: --
693:
694: -- Checking the Psb_set_relations table for references.
695: OPEN c;
696: FETCH c INTO l_tmp;
697:
698: -- p_Return_Value specifies whether unique value exists or not.

Line 826: FROM psb_set_relations rel ,

822: FOR l_ccid_rec IN
823: (
824: SELECT pba.account_position_set_id,
825: pba.code_combination_id
826: FROM psb_set_relations rel ,
827: psb_budget_accounts pba
828: WHERE rel.gl_budget_id = l_gl_budget_rec.gl_budget_id
829: AND pba.account_position_set_id = rel.account_position_set_id
830: )

Line 843: psb_set_relations rel ,

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
847: AND rel.gl_budget_id = gb.gl_budget_id