99: pqh_budgets bgt,
100: pqh_budget_versions bvr,
101: pqh_budget_details bdt
102: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
103: pqh_budget_periods bpr,
104: per_time_periods ptps,
105: per_time_periods ptpe
106: */
107: WHERE
125: pqh_budgets bgt,
126: pqh_budget_versions bvr,
127: pqh_budget_details bdt
128: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
129: pqh_budget_periods bpr,
130: per_time_periods ptps,
131: per_time_periods ptpe
132: */
133: WHERE
153: pqh_budget_versions bvr,
154: pqh_budget_details bdt
155: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
156:
157: pqh_budget_periods bpr,
158: per_time_periods ptps,
159: per_time_periods ptpe */
160: WHERE
161: bgt.budget_id = bvr.budget_id
226: pqh_budgets bgt,
227: pqh_budget_versions bvr,
228: pqh_budget_details bdt
229: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
230: pqh_budget_periods bpr,
231: per_time_periods ptps,
232: per_time_periods ptpe
233: */
234: WHERE
252: pqh_budgets bgt,
253: pqh_budget_versions bvr,
254: pqh_budget_details bdt
255: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
256: pqh_budget_periods bpr,
257: per_time_periods ptps,
258: per_time_periods ptpe
259: */
260: WHERE
278: pqh_budgets bgt,
279: pqh_budget_versions bvr,
280: pqh_budget_details bdt
281: /*changed for bug#3784023. Now budgeted values will be reported from budget details
282: pqh_budget_periods bpr,
283: per_time_periods ptps,
284: per_time_periods ptpe
285: */
286: WHERE
304: pqh_budgets bgt,
305: pqh_budget_versions bvr,
306: pqh_budget_details bdt
307: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
308: pqh_budget_periods bpr,
309: per_time_periods ptps,
310: per_time_periods ptpe
311: */
312: WHERE
330: pqh_budgets bgt,
331: pqh_budget_versions bvr,
332: pqh_budget_details bdt
333: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
334: pqh_budget_periods bpr,
335: per_time_periods ptps,
336: per_time_periods ptpe
337: */
338: WHERE
356: pqh_budgets bgt,
357: pqh_budget_versions bvr,
358: pqh_budget_details bdt
359: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
360: pqh_budget_periods bpr,
361: per_time_periods ptps,
362: per_time_periods ptpe
363: */
364: WHERE
384: pqh_budget_versions bvr,
385: pqh_budget_details bdt
386: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
387:
388: pqh_budget_periods bpr,
389: per_time_periods ptps,
390: per_time_periods ptpe
391: */
392: WHERE
410: pqh_budgets bgt,
411: pqh_budget_versions bvr,
412: pqh_budget_details bdt
413: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
414: pqh_budget_periods bpr,
415: per_time_periods ptps,
416: per_time_periods ptpe
417: */
418: WHERE
437: pqh_budgets bgt,
438: pqh_budget_versions bvr,
439: pqh_budget_details bdt
440: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
441: pqh_budget_periods bpr,
442: per_time_periods ptps,
443: per_time_periods ptpe
444: */
445: WHERE
543: FROM
544: pqh_budgets bgt,
545: pqh_budget_versions bvr,
546: pqh_budget_details bdt,
547: pqh_budget_periods bpr,
548: per_time_periods ptps,
549: per_time_periods ptpe,
550: pqh_budget_sets bst,
551: pqh_budget_elements bel
571: FROM
572: pqh_budgets bgt,
573: pqh_budget_versions bvr,
574: pqh_budget_details bdt,
575: pqh_budget_periods bpr,
576: per_time_periods ptps,
577: per_time_periods ptpe,
578: pqh_budget_sets bst,
579: pqh_budget_elements bel
599: FROM
600: pqh_budgets bgt,
601: pqh_budget_versions bvr,
602: pqh_budget_details bdt,
603: pqh_budget_periods bpr,
604: per_time_periods ptps,
605: per_time_periods ptpe,
606: pqh_budget_sets bst,
607: pqh_budget_elements bel
673: FROM
674: pqh_budgets bgt,
675: pqh_budget_versions bvr,
676: pqh_budget_details bdt,
677: pqh_budget_periods bpr,
678: per_time_periods ptps,
679: per_time_periods ptpe,
680: pqh_budget_sets bst
681: WHERE
699: FROM
700: pqh_budgets bgt,
701: pqh_budget_versions bvr,
702: pqh_budget_details bdt,
703: pqh_budget_periods bpr,
704: per_time_periods ptps,
705: per_time_periods ptpe,
706: pqh_budget_sets bst
707: WHERE
725: FROM
726: pqh_budgets bgt,
727: pqh_budget_versions bvr,
728: pqh_budget_details bdt,
729: pqh_budget_periods bpr,
730: per_time_periods ptps,
731: per_time_periods ptpe,
732: pqh_budget_sets bst
733: WHERE
1566: FROM
1567: pqh_budgets bgt,
1568: pqh_budget_versions bvr,
1569: pqh_budget_details bdt,
1570: pqh_budget_periods bpr,
1571: per_time_periods ptps,
1572: per_time_periods ptpe,
1573: pqh_budget_sets bst,
1574: pqh_budget_elements bel
1595: FROM
1596: pqh_budgets bgt,
1597: pqh_budget_versions bvr,
1598: pqh_budget_details bdt,
1599: pqh_budget_periods bpr,
1600: per_time_periods ptps,
1601: per_time_periods ptpe,
1602: pqh_budget_sets bst,
1603: pqh_budget_elements bel
1626: FROM
1627: pqh_budgets bgt,
1628: pqh_budget_versions bvr,
1629: pqh_budget_details bdt,
1630: pqh_budget_periods bpr,
1631: per_time_periods ptps,
1632: per_time_periods ptpe,
1633: pqh_budget_sets bst,
1634: pqh_budget_elements bel
1801: FROM
1802: pqh_budgets bgt,
1803: pqh_budget_versions bvr,
1804: pqh_budget_details bdt,
1805: pqh_budget_periods bpr,
1806: per_time_periods ptps,
1807: per_time_periods ptpe,
1808: pqh_budget_sets bst,
1809: pqh_budget_elements bel
1830: FROM
1831: pqh_budgets bgt,
1832: pqh_budget_versions bvr,
1833: pqh_budget_details bdt,
1834: pqh_budget_periods bpr,
1835: per_time_periods ptps,
1836: per_time_periods ptpe,
1837: pqh_budget_sets bst,
1838: pqh_budget_elements bel
1861: FROM
1862: pqh_budgets bgt,
1863: pqh_budget_versions bvr,
1864: pqh_budget_details bdt,
1865: pqh_budget_periods bpr,
1866: per_time_periods ptps,
1867: per_time_periods ptpe,
1868: pqh_budget_sets bst,
1869: pqh_budget_elements bel
2039: FROM
2040: pqh_budgets bgt,
2041: pqh_budget_versions bvr,
2042: pqh_budget_details bdt,
2043: pqh_budget_periods bpr,
2044: per_time_periods ptps,
2045: per_time_periods ptpe,
2046: pqh_budget_sets bst,
2047: pqh_budget_elements bel
2068: FROM
2069: pqh_budgets bgt,
2070: pqh_budget_versions bvr,
2071: pqh_budget_details bdt,
2072: pqh_budget_periods bpr,
2073: per_time_periods ptps,
2074: per_time_periods ptpe,
2075: pqh_budget_sets bst,
2076: pqh_budget_elements bel
2099: FROM
2100: pqh_budgets bgt,
2101: pqh_budget_versions bvr,
2102: pqh_budget_details bdt,
2103: pqh_budget_periods bpr,
2104: per_time_periods ptps,
2105: per_time_periods ptpe,
2106: pqh_budget_sets bst,
2107: pqh_budget_elements bel
2321: FROM
2322: pqh_budgets bgt,
2323: pqh_budget_versions bvr,
2324: pqh_budget_details bdt,
2325: pqh_budget_periods bpr,
2326: pqh_budget_sets bst,
2327: pqh_budget_elements bel
2328: WHERE
2329: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )
2440: FROM
2441: pqh_budgets bgt,
2442: pqh_budget_versions bvr,
2443: pqh_budget_details bdt,
2444: pqh_budget_periods bpr,
2445: pqh_budget_sets bst,
2446: pqh_budget_elements bel
2447: WHERE
2448: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )
2557: FROM
2558: pqh_budgets bgt,
2559: pqh_budget_versions bvr,
2560: pqh_budget_details bdt,
2561: pqh_budget_periods bpr,
2562: pqh_budget_sets bst,
2563: pqh_budget_elements bel
2564: WHERE
2565: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )
2673: FROM
2674: pqh_budgets bgt,
2675: pqh_budget_versions bvr,
2676: pqh_budget_details bdt,
2677: pqh_budget_periods bpr,
2678: pqh_budget_sets bst,
2679: pqh_budget_elements bel
2680: WHERE
2681: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )
2775: FROM
2776: pqh_budgets bgt,
2777: pqh_budget_versions bvr,
2778: pqh_budget_details bdt,
2779: pqh_budget_periods bpr,
2780: pqh_budget_sets bst
2781: WHERE
2782: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )
2783: AND bgt.budget_id = bvr.budget_id
3617: FROM
3618: pqh_budgets bgt,
3619: pqh_budget_versions bvr,
3620: pqh_budget_details bdt,
3621: pqh_budget_periods bpr,
3622: pqh_budget_sets bst,
3623: pqh_budget_elements bel
3624: WHERE
3625: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
3725: FROM
3726: pqh_budgets bgt,
3727: pqh_budget_versions bvr,
3728: pqh_budget_details bdt,
3729: pqh_budget_periods bpr,
3730: pqh_budget_sets bst,
3731: pqh_budget_elements bel
3732: WHERE
3733: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
3832: FROM
3833: pqh_budgets bgt,
3834: pqh_budget_versions bvr,
3835: pqh_budget_details bdt,
3836: pqh_budget_periods bpr,
3837: pqh_budget_sets bst,
3838: pqh_budget_elements bel
3839: WHERE
3840: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
3939: FROM
3940: pqh_budgets bgt,
3941: pqh_budget_versions bvr,
3942: pqh_budget_details bdt,
3943: pqh_budget_periods bpr,
3944: pqh_budget_sets bst,
3945: pqh_budget_elements bel
3946: WHERE
3947: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )