APPS.PQH_PSP_INTEGRATION dependencies on PQH_BUDGET_DETAILS

Line 208: From pqh_budget_details bdt,

204: Cursor csr_position_budget(p_position_id NUMBER,
205: p_start_date date,
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

Line 229: From pqh_budget_details bdt,

225: Cursor csr_org_budget(p_organization_id NUMBER,
226: p_start_date date,
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

Line 251: From pqh_budget_details bdt,

247: Cursor csr_grade_budget(p_grade_id NUMBER,
248: p_start_date date,
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

Line 272: From pqh_budget_details bdt,

268: Cursor csr_job_budget(p_job_id NUMBER,
269: p_start_date date,
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

Line 328: Update pqh_budget_details

324: IF ( not version_repeated )
325: THEN
326: i :=i+1;
327: l_versions_tab(i) :=C1.budget_version_id;
328: Update pqh_budget_details
329: SET commitment_gl_status='ENC',gl_status='ENC'
330: Where budget_detail_id = C1.budget_detail_id;
331: END IF;
332: --

Line 360: Update pqh_budget_details

356: IF ( not version_repeated )
357: THEN
358: i :=i+1;
359: l_versions_tab(i) :=C1.budget_version_id;
360: Update pqh_budget_details
361: SET commitment_gl_status='ENC',gl_status='ENC'
362: Where budget_detail_id = C1.budget_detail_id;
363: END IF;
364: --

Line 392: Update pqh_budget_details

388: IF ( not version_repeated )
389: THEN
390: i :=i+1;
391: l_versions_tab(i) :=C1.budget_version_id;
392: Update pqh_budget_details
393: SET commitment_gl_status='ENC',gl_status='ENC'
394: Where budget_detail_id = C1.budget_detail_id;
395: END IF;
396: --

Line 424: Update pqh_budget_details

420: IF ( not version_repeated )
421: THEN
422: i :=i+1;
423: l_versions_tab(i) :=C1.budget_version_id;
424: Update pqh_budget_details
425: SET commitment_gl_status='ENC',gl_status='ENC'
426: Where budget_detail_id = C1.budget_detail_id;
427: END IF;
428: --