DBA Data[Home] [Help]

APPS.PQH_BFS_BUS dependencies on PQH_BUDGET_FUND_SRCS

Line 139: pqh_bfs_shd.constraint_error('PQH_BUDGET_FUND_SRCS_FK1');

135: --
136: -- raise error as FK does not relate to PK in pqh_budget_elements
137: -- table.
138: --
139: pqh_bfs_shd.constraint_error('PQH_BUDGET_FUND_SRCS_FK1');
140: --
141: end if;
142: --
143: close c1;

Line 170: from pqh_budget_fund_srcs

166: l_dummy varchar2(1) ;
167:
168: cursor csr_src is
169: select 'X'
170: from pqh_budget_fund_srcs
171: where budget_element_id = p_budget_element_id
172: and budget_fund_src_id <> nvl(p_budget_fund_src_id,0)
173: and nvl(cost_allocation_keyflex_id,0) = nvl(p_cost_allocation_keyflex_id,0)
174: and nvl(project_id,0) = nvl(p_project_id,0)