APPS.PQH_EFC dependencies on PER_SHARED_TYPES_VL

Line 279: per_shared_types_vl pst1 ,

275: pst2.system_type_cd ,
276: pst3.system_type_cd
277: FROM pqh_budgets bgt,
278: pqh_budget_versions bvr,
279: per_shared_types_vl pst1 ,
280: per_shared_types_vl pst2 ,
281: per_shared_types_vl pst3
282: WHERE bgt.budget_id = bvr.budget_id
283: AND bgt.budget_unit1_id = pst1.shared_type_id (+)

Line 280: per_shared_types_vl pst2 ,

276: pst3.system_type_cd
277: FROM pqh_budgets bgt,
278: pqh_budget_versions bvr,
279: per_shared_types_vl pst1 ,
280: per_shared_types_vl pst2 ,
281: per_shared_types_vl pst3
282: WHERE bgt.budget_id = bvr.budget_id
283: AND bgt.budget_unit1_id = pst1.shared_type_id (+)
284: AND bgt.budget_unit2_id = pst2.shared_type_id (+)

Line 281: per_shared_types_vl pst3

277: FROM pqh_budgets bgt,
278: pqh_budget_versions bvr,
279: per_shared_types_vl pst1 ,
280: per_shared_types_vl pst2 ,
281: per_shared_types_vl pst3
282: WHERE bgt.budget_id = bvr.budget_id
283: AND bgt.budget_unit1_id = pst1.shared_type_id (+)
284: AND bgt.budget_unit2_id = pst2.shared_type_id (+)
285: AND bgt.budget_unit3_id = pst3.shared_type_id (+)

Line 296: per_shared_types_vl pst1 ,

292: pst3.system_type_cd
293: FROM pqh_budgets bgt,
294: pqh_budget_versions bvr,
295: pqh_budget_details bdt,
296: per_shared_types_vl pst1 ,
297: per_shared_types_vl pst2 ,
298: per_shared_types_vl pst3
299: WHERE bgt.budget_id = bvr.budget_id
300: AND bvr.budget_version_id = bdt.budget_version_id

Line 297: per_shared_types_vl pst2 ,

293: FROM pqh_budgets bgt,
294: pqh_budget_versions bvr,
295: pqh_budget_details bdt,
296: per_shared_types_vl pst1 ,
297: per_shared_types_vl pst2 ,
298: per_shared_types_vl pst3
299: WHERE bgt.budget_id = bvr.budget_id
300: AND bvr.budget_version_id = bdt.budget_version_id
301: AND bgt.budget_unit1_id = pst1.shared_type_id (+)

Line 298: per_shared_types_vl pst3

294: pqh_budget_versions bvr,
295: pqh_budget_details bdt,
296: per_shared_types_vl pst1 ,
297: per_shared_types_vl pst2 ,
298: per_shared_types_vl pst3
299: WHERE bgt.budget_id = bvr.budget_id
300: AND bvr.budget_version_id = bdt.budget_version_id
301: AND bgt.budget_unit1_id = pst1.shared_type_id (+)
302: AND bgt.budget_unit2_id = pst2.shared_type_id (+)

Line 315: per_shared_types_vl pst1 ,

311: FROM pqh_budgets bgt,
312: pqh_budget_versions bvr,
313: pqh_budget_details bdt,
314: pqh_budget_periods bpr,
315: per_shared_types_vl pst1 ,
316: per_shared_types_vl pst2 ,
317: per_shared_types_vl pst3
318: WHERE bgt.budget_id = bvr.budget_id
319: AND bvr.budget_version_id = bdt.budget_version_id

Line 316: per_shared_types_vl pst2 ,

312: pqh_budget_versions bvr,
313: pqh_budget_details bdt,
314: pqh_budget_periods bpr,
315: per_shared_types_vl pst1 ,
316: per_shared_types_vl pst2 ,
317: per_shared_types_vl pst3
318: WHERE bgt.budget_id = bvr.budget_id
319: AND bvr.budget_version_id = bdt.budget_version_id
320: AND bdt.budget_detail_id = bpr.budget_detail_id

Line 317: per_shared_types_vl pst3

313: pqh_budget_details bdt,
314: pqh_budget_periods bpr,
315: per_shared_types_vl pst1 ,
316: per_shared_types_vl pst2 ,
317: per_shared_types_vl pst3
318: WHERE bgt.budget_id = bvr.budget_id
319: AND bvr.budget_version_id = bdt.budget_version_id
320: AND bdt.budget_detail_id = bpr.budget_detail_id
321: AND bgt.budget_unit1_id = pst1.shared_type_id (+)

Line 336: per_shared_types_vl pst1 ,

332: pqh_budget_versions bvr,
333: pqh_budget_details bdt,
334: pqh_budget_periods bpr,
335: pqh_budget_sets bst,
336: per_shared_types_vl pst1 ,
337: per_shared_types_vl pst2 ,
338: per_shared_types_vl pst3
339: WHERE bgt.budget_id = bvr.budget_id
340: AND bvr.budget_version_id = bdt.budget_version_id

Line 337: per_shared_types_vl pst2 ,

333: pqh_budget_details bdt,
334: pqh_budget_periods bpr,
335: pqh_budget_sets bst,
336: per_shared_types_vl pst1 ,
337: per_shared_types_vl pst2 ,
338: per_shared_types_vl pst3
339: WHERE bgt.budget_id = bvr.budget_id
340: AND bvr.budget_version_id = bdt.budget_version_id
341: AND bdt.budget_detail_id = bpr.budget_detail_id

Line 338: per_shared_types_vl pst3

334: pqh_budget_periods bpr,
335: pqh_budget_sets bst,
336: per_shared_types_vl pst1 ,
337: per_shared_types_vl pst2 ,
338: per_shared_types_vl pst3
339: WHERE bgt.budget_id = bvr.budget_id
340: AND bvr.budget_version_id = bdt.budget_version_id
341: AND bdt.budget_detail_id = bpr.budget_detail_id
342: AND bpr.budget_period_id = bst.budget_period_id

Line 356: per_shared_types_vl pst1 ,

352: pst3.system_type_cd
353: FROM pqh_budgets bgt,
354: pqh_worksheets wks,
355: pqh_worksheet_details wdt,
356: per_shared_types_vl pst1 ,
357: per_shared_types_vl pst2 ,
358: per_shared_types_vl pst3
359: WHERE bgt.budget_id = wks.budget_id
360: AND wks.worksheet_id = wdt.worksheet_id

Line 357: per_shared_types_vl pst2 ,

353: FROM pqh_budgets bgt,
354: pqh_worksheets wks,
355: pqh_worksheet_details wdt,
356: per_shared_types_vl pst1 ,
357: per_shared_types_vl pst2 ,
358: per_shared_types_vl pst3
359: WHERE bgt.budget_id = wks.budget_id
360: AND wks.worksheet_id = wdt.worksheet_id
361: AND bgt.budget_unit1_id = pst1.shared_type_id (+)

Line 358: per_shared_types_vl pst3

354: pqh_worksheets wks,
355: pqh_worksheet_details wdt,
356: per_shared_types_vl pst1 ,
357: per_shared_types_vl pst2 ,
358: per_shared_types_vl pst3
359: WHERE bgt.budget_id = wks.budget_id
360: AND wks.worksheet_id = wdt.worksheet_id
361: AND bgt.budget_unit1_id = pst1.shared_type_id (+)
362: AND bgt.budget_unit2_id = pst2.shared_type_id (+)

Line 375: per_shared_types_vl pst1 ,

371: FROM pqh_budgets bgt,
372: pqh_worksheets wks,
373: pqh_worksheet_details wdt,
374: pqh_worksheet_periods wpr,
375: per_shared_types_vl pst1 ,
376: per_shared_types_vl pst2 ,
377: per_shared_types_vl pst3
378: WHERE bgt.budget_id = wks.budget_id
379: AND wks.worksheet_id = wdt.worksheet_id

Line 376: per_shared_types_vl pst2 ,

372: pqh_worksheets wks,
373: pqh_worksheet_details wdt,
374: pqh_worksheet_periods wpr,
375: per_shared_types_vl pst1 ,
376: per_shared_types_vl pst2 ,
377: per_shared_types_vl pst3
378: WHERE bgt.budget_id = wks.budget_id
379: AND wks.worksheet_id = wdt.worksheet_id
380: AND wdt.worksheet_detail_id = wpr.worksheet_detail_id

Line 377: per_shared_types_vl pst3

373: pqh_worksheet_details wdt,
374: pqh_worksheet_periods wpr,
375: per_shared_types_vl pst1 ,
376: per_shared_types_vl pst2 ,
377: per_shared_types_vl pst3
378: WHERE bgt.budget_id = wks.budget_id
379: AND wks.worksheet_id = wdt.worksheet_id
380: AND wdt.worksheet_detail_id = wpr.worksheet_detail_id
381: AND bgt.budget_unit1_id = pst1.shared_type_id (+)

Line 396: per_shared_types_vl pst1 ,

392: pqh_worksheets wks,
393: pqh_worksheet_details wdt,
394: pqh_worksheet_periods wpr,
395: pqh_worksheet_budget_sets wst,
396: per_shared_types_vl pst1 ,
397: per_shared_types_vl pst2 ,
398: per_shared_types_vl pst3
399: WHERE bgt.budget_id = wks.budget_id
400: AND wks.worksheet_id = wdt.worksheet_id

Line 397: per_shared_types_vl pst2 ,

393: pqh_worksheet_details wdt,
394: pqh_worksheet_periods wpr,
395: pqh_worksheet_budget_sets wst,
396: per_shared_types_vl pst1 ,
397: per_shared_types_vl pst2 ,
398: per_shared_types_vl pst3
399: WHERE bgt.budget_id = wks.budget_id
400: AND wks.worksheet_id = wdt.worksheet_id
401: AND wdt.worksheet_detail_id = wpr.worksheet_detail_id

Line 398: per_shared_types_vl pst3

394: pqh_worksheet_periods wpr,
395: pqh_worksheet_budget_sets wst,
396: per_shared_types_vl pst1 ,
397: per_shared_types_vl pst2 ,
398: per_shared_types_vl pst3
399: WHERE bgt.budget_id = wks.budget_id
400: AND wks.worksheet_id = wdt.worksheet_id
401: AND wdt.worksheet_detail_id = wpr.worksheet_detail_id
402: AND wpr.worksheet_period_id = wst.worksheet_period_id

Line 414: per_shared_types_vl pst1

410: CURSOR csr_bre_unit IS
411: SELECT pst1.system_type_cd
412: FROM pqh_bdgt_pool_realloctions bre,
413: pqh_budget_pools bpl,
414: per_shared_types_vl pst1
415: WHERE bre.pool_id = bpl.pool_id
416: AND bpl.budget_unit_id = pst1.shared_type_id
417: AND bre.reallocation_id = p_primary_key;
418: --