DBA Data[Home] [Help]

APPS.PQH_PSP_INTEGRATION dependencies on PQH_BUDGETS

Line 210: pqh_budgets bgt

206: p_end_date date) IS
207: Select bdt.budget_detail_id ,bdt.budget_version_id
208: From pqh_budget_details bdt,
209: pqh_budget_versions bvr,
210: pqh_budgets bgt
211: Where
212: bdt.position_id=p_position_id And
213: bdt.gl_status='POST' And
214: bvr.budget_version_id=bdt.budget_version_id And

Line 231: pqh_budgets bgt

227: p_end_date date) IS
228: Select bdt.budget_detail_id ,bdt.budget_version_id
229: From pqh_budget_details bdt,
230: pqh_budget_versions bvr,
231: pqh_budgets bgt
232: Where
233: bdt.organization_id=p_organization_id And
234: bdt.gl_status='POST' And
235: bvr.budget_version_id=bdt.budget_version_id And

Line 253: pqh_budgets bgt

249: p_end_date date) IS
250: Select bdt.budget_detail_id ,bdt.budget_version_id
251: From pqh_budget_details bdt,
252: pqh_budget_versions bvr,
253: pqh_budgets bgt
254: Where
255: bdt.grade_id=p_grade_id And
256: bdt.gl_status='POST' And
257: bvr.budget_version_id=bdt.budget_version_id And

Line 274: pqh_budgets bgt

270: p_end_date date) IS
271: Select bdt.budget_detail_id ,bdt.budget_version_id
272: From pqh_budget_details bdt,
273: pqh_budget_versions bvr,
274: pqh_budgets bgt
275: Where
276: bdt.job_id=p_job_id And
277: bdt.gl_status='POST' And
278: bvr.budget_version_id=bdt.budget_version_id And