eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_MGMT_RPT_PKG dependencies on PQH_BUDGET_DETAILS

Line 101: pqh_budget_details bdt

97: SELECT bdt.budget_unit1_value
98: FROM
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

Line 127: pqh_budget_details bdt

123: SELECT bdt.budget_unit2_value
124: FROM
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

Line 154: pqh_budget_details bdt

150: SELECT bdt.budget_unit3_value
151: FROM
152: pqh_budgets bgt,
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,

Line 228: pqh_budget_details bdt

224: SELECT bdt.budget_unit1_value
225: FROM
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

Line 254: pqh_budget_details bdt

250: SELECT bdt.budget_unit2_value
251: FROM
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

Line 280: pqh_budget_details bdt

276: SELECT bdt.budget_unit3_value
277: FROM
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

Line 306: pqh_budget_details bdt

302: SELECT bdt.budget_unit1_value
303: FROM
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

Line 332: pqh_budget_details bdt

328: SELECT bdt.budget_unit2_value
329: FROM
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

Line 358: pqh_budget_details bdt

354: SELECT bdt.budget_unit3_value
355: FROM
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

Line 385: pqh_budget_details bdt

381: SELECT bdt.budget_unit1_value
382: FROM
383: pqh_budgets bgt,
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,

Line 412: pqh_budget_details bdt

408: SELECT bdt.budget_unit2_value
409: FROM
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

Line 439: pqh_budget_details bdt

435: SELECT bdt.budget_unit3_value
436: FROM
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

Line 546: pqh_budget_details bdt,

542: SUM(bst.budget_unit1_value * NVL(bel.distribution_percentage/100,0))
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,

Line 574: pqh_budget_details bdt,

570: SUM(bst.budget_unit2_value * NVL(bel.distribution_percentage/100,0))
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,

Line 602: pqh_budget_details bdt,

598: SUM(bst.budget_unit3_value * NVL(bel.distribution_percentage/100,0))
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,

Line 676: pqh_budget_details bdt,

672: SUM(bst.budget_unit1_value)
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

Line 702: pqh_budget_details bdt,

698: SUM(bst.budget_unit2_value )
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

Line 728: pqh_budget_details bdt,

724: SUM(bst.budget_unit3_value)
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

Line 887: pqh_budget_details bdt

883: bgt.budget_id
884: FROM
885: pqh_budgets bgt,
886: pqh_budget_versions bvr,
887: pqh_budget_details bdt
888: WHERE
889: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
890: AND bgt.budget_id = bvr.budget_id
891: AND bvr.budget_version_id = bdt.budget_version_id

Line 1053: pqh_budget_details bdt

1049: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1050: FROM
1051: pqh_budgets bgt,
1052: pqh_budget_versions bvr,
1053: pqh_budget_details bdt
1054: WHERE
1055: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
1056: AND bgt.budget_id = bvr.budget_id
1057: AND bvr.budget_version_id = bdt.budget_version_id

Line 1073: pqh_budget_details bdt

1069: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1070: FROM
1071: pqh_budgets bgt,
1072: pqh_budget_versions bvr,
1073: pqh_budget_details bdt
1074: WHERE
1075: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
1076: AND bgt.budget_id = bvr.budget_id
1077: AND bvr.budget_version_id = bdt.budget_version_id

Line 1093: pqh_budget_details bdt

1089: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1090: FROM
1091: pqh_budgets bgt,
1092: pqh_budget_versions bvr,
1093: pqh_budget_details bdt
1094: WHERE
1095: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
1096: AND bgt.budget_id = bvr.budget_id
1097: AND bvr.budget_version_id = bdt.budget_version_id

Line 1389: pqh_budget_details bdt

1385: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1386: FROM
1387: pqh_budgets bgt,
1388: pqh_budget_versions bvr,
1389: pqh_budget_details bdt
1390: WHERE
1391: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
1392: AND bgt.budget_id = bvr.budget_id
1393: AND bvr.budget_version_id = bdt.budget_version_id

Line 1410: pqh_budget_details bdt

1406: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1407: FROM
1408: pqh_budgets bgt,
1409: pqh_budget_versions bvr,
1410: pqh_budget_details bdt
1411: WHERE
1412: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
1413: AND bgt.budget_id = bvr.budget_id
1414: AND bvr.budget_version_id = bdt.budget_version_id

Line 1431: pqh_budget_details bdt

1427: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1428: FROM
1429: pqh_budgets bgt,
1430: pqh_budget_versions bvr,
1431: pqh_budget_details bdt
1432: WHERE
1433: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
1434: AND bgt.budget_id = bvr.budget_id
1435: AND bvr.budget_version_id = bdt.budget_version_id

Line 1569: pqh_budget_details bdt,

1565: SUM(bst.budget_unit1_value * NVL(bel.distribution_percentage/100,0))
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,

Line 1598: pqh_budget_details bdt,

1594: SUM(bst.budget_unit2_value * NVL(bel.distribution_percentage/100,0))
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,

Line 1629: pqh_budget_details bdt,

1625: SUM(bst.budget_unit3_value * NVL(bel.distribution_percentage/100,0))
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,

Line 1715: pqh_budget_details bdt

1711: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1712: FROM
1713: pqh_budgets bgt,
1714: pqh_budget_versions bvr,
1715: pqh_budget_details bdt
1716: WHERE
1717: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )
1718: AND bgt.budget_id = bvr.budget_id
1719: AND bvr.budget_version_id = bdt.budget_version_id

Line 1804: pqh_budget_details bdt,

1800: SUM(bst.budget_unit1_value * NVL(bel.distribution_percentage/100,0))
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,

Line 1833: pqh_budget_details bdt,

1829: SUM(bst.budget_unit2_value * NVL(bel.distribution_percentage/100,0))
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,

Line 1864: pqh_budget_details bdt,

1860: SUM(bst.budget_unit3_value * NVL(bel.distribution_percentage/100,0))
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,

Line 1954: pqh_budget_details bdt

1950: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1951: FROM
1952: pqh_budgets bgt,
1953: pqh_budget_versions bvr,
1954: pqh_budget_details bdt
1955: WHERE
1956: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )
1957: AND bgt.budget_id = bvr.budget_id
1958: AND bvr.budget_version_id = bdt.budget_version_id

Line 2042: pqh_budget_details bdt,

2038: SUM(bst.budget_unit1_value * NVL(bel.distribution_percentage/100,0))
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,

Line 2071: pqh_budget_details bdt,

2067: SUM(bst.budget_unit2_value * NVL(bel.distribution_percentage/100,0))
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,

Line 2102: pqh_budget_details bdt,

2098: SUM(bst.budget_unit3_value * NVL(bel.distribution_percentage/100,0))
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,

Line 2188: pqh_budget_details bdt

2184: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
2185: FROM
2186: pqh_budgets bgt,
2187: pqh_budget_versions bvr,
2188: pqh_budget_details bdt
2189: WHERE
2190: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )
2191: AND bgt.budget_id = bvr.budget_id
2192: AND bvr.budget_version_id = bdt.budget_version_id

Line 2324: pqh_budget_details bdt,

2320: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
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

Line 2443: pqh_budget_details bdt,

2439: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
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

Line 2560: pqh_budget_details bdt,

2556: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
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

Line 2676: pqh_budget_details bdt,

2672: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
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

Line 2778: pqh_budget_details bdt,

2774: bvr.BUDGET_VERSION_ID BUDGET_VERSION_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 )

Line 2859: p_organization_id IN pqh_budget_details.organization_id%TYPE,

2855: END get_posn_bset_actual_cmmtmnts;
2856: ---------------------------------------------------------------------------------------------------------
2857: FUNCTION get_org_posn_budget_amt
2858: (
2859: p_organization_id IN pqh_budget_details.organization_id%TYPE,
2860: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2861: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2862: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2863: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 2870: l_position_id pqh_budget_details.position_id%TYPE;

2866: /*
2867: */
2868: l_proc varchar2(72) := g_package||'get_org_posn_budget_amt';
2869: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
2870: l_position_id pqh_budget_details.position_id%TYPE;
2871: l_total_amt NUMBER := 0;
2872: l_curr_posn_tot NUMBER := 0;
2873:
2874: l_currency_code fnd_currencies.currency_code%TYPE;

Line 2886: pqh_budget_details bdt

2882: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
2883: FROM
2884: pqh_budgets bgt,
2885: pqh_budget_versions bvr,
2886: pqh_budget_details bdt
2887: WHERE
2888: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
2889: AND bgt.budget_id = bvr.budget_id
2890: AND bvr.budget_version_id = bdt.budget_version_id

Line 2947: p_organization_id IN pqh_budget_details.organization_id%TYPE,

2943:
2944: ---------------------------------------------------------------------------------------------------------
2945: FUNCTION get_org_posn_actual_cmmtmnts
2946: (
2947: p_organization_id IN pqh_budget_details.organization_id%TYPE,
2948: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2949: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2950: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2951: p_value_type IN varchar2 DEFAULT 'T',

Line 2960: l_position_id pqh_budget_details.position_id%TYPE;

2956: */
2957:
2958: l_proc varchar2(72) := g_package||'get_org_posn_actual_cmmtmnts';
2959: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
2960: l_position_id pqh_budget_details.position_id%TYPE;
2961: l_total_amt NUMBER := 0;
2962: l_curr_posn_tot NUMBER := 0;
2963:
2964: l_currency_code fnd_currencies.currency_code%TYPE;

Line 2976: pqh_budget_details bdt

2972: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
2973: FROM
2974: pqh_budgets bgt,
2975: pqh_budget_versions bvr,
2976: pqh_budget_details bdt
2977: WHERE
2978: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
2979: AND bgt.budget_id = bvr.budget_id
2980: AND bvr.budget_version_id = bdt.budget_version_id

Line 3049: l_position_id pqh_budget_details.position_id%TYPE;

3045: RETURN NUMBER IS
3046:
3047: l_proc varchar2(72) := g_package||'get_bgrp_posn_budget_amt';
3048: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
3049: l_position_id pqh_budget_details.position_id%TYPE;
3050: l_total_amt NUMBER := 0;
3051: l_curr_posn_tot NUMBER := 0;
3052:
3053: l_currency_code fnd_currencies.currency_code%TYPE;

Line 3064: pqh_budget_details bdt

3060: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3061: FROM
3062: pqh_budgets bgt,
3063: pqh_budget_versions bvr,
3064: pqh_budget_details bdt
3065: WHERE bgt.business_group_id = p_business_group_id
3066: AND bgt.budget_id = bvr.budget_id
3067: AND bvr.budget_version_id = bdt.budget_version_id
3068: AND (bgt.budget_unit1_id = p_unit_of_measure_id or

Line 3132: l_position_id pqh_budget_details.position_id%TYPE;

3128: RETURN NUMBER IS
3129:
3130: l_proc varchar2(72) := g_package||'get_bgrp_posn_actual_cmmtmnts';
3131: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
3132: l_position_id pqh_budget_details.position_id%TYPE;
3133: l_total_amt NUMBER := 0;
3134: l_curr_posn_tot NUMBER := 0;
3135:
3136: l_currency_code fnd_currencies.currency_code%TYPE;

Line 3147: pqh_budget_details bdt

3143: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3144: FROM
3145: pqh_budgets bgt,
3146: pqh_budget_versions bvr,
3147: pqh_budget_details bdt
3148: WHERE
3149: bgt.business_group_id = p_business_group_id
3150: AND bgt.budget_id = bvr.budget_id
3151: AND bvr.budget_version_id = bdt.budget_version_id

Line 3218: l_position_id pqh_budget_details.position_id%TYPE;

3214: RETURN NUMBER IS
3215:
3216: l_proc varchar2(72) := g_package||'get_elem_posn_budget_amt';
3217: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
3218: l_position_id pqh_budget_details.position_id%TYPE;
3219: l_total_amt NUMBER := 0;
3220: l_curr_posn_tot NUMBER := 0;
3221:
3222: l_currency_code fnd_currencies.currency_code%TYPE;

Line 3234: pqh_budget_details bdt

3230: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3231: FROM
3232: pqh_budgets bgt,
3233: pqh_budget_versions bvr,
3234: pqh_budget_details bdt
3235: WHERE
3236: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
3237: AND bgt.budget_id = bvr.budget_id
3238: AND bvr.budget_version_id = bdt.budget_version_id

Line 3314: l_job_id pqh_budget_details.job_id%TYPE;

3310: RETURN NUMBER IS
3311:
3312: l_proc varchar2(72) := g_package||'get_elem_job_budget_amt';
3313: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
3314: l_job_id pqh_budget_details.job_id%TYPE;
3315: l_total_amt NUMBER := 0;
3316: l_curr_posn_tot NUMBER := 0;
3317:
3318: l_currency_code fnd_currencies.currency_code%TYPE;

Line 3330: pqh_budget_details bdt

3326: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3327: FROM
3328: pqh_budgets bgt,
3329: pqh_budget_versions bvr,
3330: pqh_budget_details bdt
3331: WHERE
3332: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
3333: AND bgt.budget_id = bvr.budget_id
3334: AND bvr.budget_version_id = bdt.budget_version_id

Line 3411: l_grade_id pqh_budget_details.grade_id%TYPE;

3407: RETURN NUMBER IS
3408:
3409: l_proc varchar2(72) := g_package||'get_elem_grd_budget_amt';
3410: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
3411: l_grade_id pqh_budget_details.grade_id%TYPE;
3412: l_total_amt NUMBER := 0;
3413: l_curr_posn_tot NUMBER := 0;
3414:
3415: l_currency_code fnd_currencies.currency_code%TYPE;

Line 3426: pqh_budget_details bdt

3422: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3423: FROM
3424: pqh_budgets bgt,
3425: pqh_budget_versions bvr,
3426: pqh_budget_details bdt
3427: WHERE
3428: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
3429: AND bgt.budget_id = bvr.budget_id
3430: AND bvr.budget_version_id = bdt.budget_version_id

Line 3506: l_organization_id pqh_budget_details.organization_id%TYPE;

3502: RETURN NUMBER IS
3503:
3504: l_proc varchar2(72) := g_package||'get_elem_org_budget_amt';
3505: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
3506: l_organization_id pqh_budget_details.organization_id%TYPE;
3507: l_total_amt NUMBER := 0;
3508: l_curr_posn_tot NUMBER := 0;
3509:
3510: l_currency_code fnd_currencies.currency_code%TYPE;

Line 3522: pqh_budget_details bdt

3518: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3519: FROM
3520: pqh_budgets bgt,
3521: pqh_budget_versions bvr,
3522: pqh_budget_details bdt
3523: WHERE
3524: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
3525: AND bgt.budget_id = bvr.budget_id
3526: AND bvr.budget_version_id = bdt.budget_version_id

Line 3604: l_position_id pqh_budget_details.position_id%TYPE;

3600: */
3601:
3602: l_proc varchar2(72) := g_package||'get_elem_posn_actual_cmmtmnts';
3603: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
3604: l_position_id pqh_budget_details.position_id%TYPE;
3605: l_total_amt NUMBER := 0;
3606: l_curr_posn_tot NUMBER := 0;
3607:
3608: l_currency_code fnd_currencies.currency_code%TYPE;

Line 3620: pqh_budget_details bdt,

3616: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
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

Line 3712: l_job_id pqh_budget_details.job_id%TYPE;

3708: */
3709:
3710: l_proc varchar2(72) := g_package||'get_elem_job_actual_cmmtmnts';
3711: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
3712: l_job_id pqh_budget_details.job_id%TYPE;
3713: l_total_amt NUMBER := 0;
3714: l_curr_job_tot NUMBER := 0;
3715:
3716: l_currency_code fnd_currencies.currency_code%TYPE;

Line 3728: pqh_budget_details bdt,

3724: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
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

Line 3819: l_grade_id pqh_budget_details.grade_id%TYPE;

3815: */
3816:
3817: l_proc varchar2(72) := g_package||'get_elem_grde_actual_cmmtmnts';
3818: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
3819: l_grade_id pqh_budget_details.grade_id%TYPE;
3820: l_total_amt NUMBER := 0;
3821: l_curr_grade_tot NUMBER := 0;
3822:
3823: l_currency_code fnd_currencies.currency_code%TYPE;

Line 3835: pqh_budget_details bdt,

3831: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
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

Line 3926: l_organization_id pqh_budget_details.organization_id%TYPE;

3922: */
3923:
3924: l_proc varchar2(72) := g_package||'get_elem_orgn_actual_cmmtmnts';
3925: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
3926: l_organization_id pqh_budget_details.organization_id%TYPE;
3927: l_total_amt NUMBER := 0;
3928: l_curr_orgn_tot NUMBER := 0;
3929:
3930: l_currency_code fnd_currencies.currency_code%TYPE;

Line 3942: pqh_budget_details bdt,

3938: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
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

Line 4666: p_entity_id IN pqh_budget_details.position_id%TYPE,

4662: FUNCTION check_ent_type_and_variance
4663: (
4664: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4665: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
4666: p_entity_id IN pqh_budget_details.position_id%TYPE,
4667: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4668: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4669: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4670: p_entity_type IN VARCHAR2 DEFAULT 'Y',

Line 4761: p_entity_id IN pqh_budget_details.position_id%TYPE,

4757: FUNCTION get_ent_element_bdgt_amt
4758: (
4759: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4760: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
4761: p_entity_id IN pqh_budget_details.position_id%TYPE,
4762: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
4763: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4764: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4765: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

Line 4847: p_entity_id IN pqh_budget_details.position_id%TYPE,

4843: FUNCTION get_ent_elmnt_actual_cmmtmnts
4844: (
4845: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4846: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
4847: p_entity_id IN pqh_budget_details.position_id%TYPE,
4848: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
4849: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4850: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4851: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,