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_ELEMENTS

Line 523: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

519: ---------------------------------------------------------------------------------------------------------
520: FUNCTION get_posn_element_bdgt
521: (
522: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
523: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
524: p_start_date IN pqh_budgets.budget_start_date%TYPE,
525: p_end_date IN pqh_budgets.budget_end_date%TYPE,
526: p_position_id IN per_positions.position_id%TYPE,
527: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE

Line 551: pqh_budget_elements bel

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
552: WHERE
553: bgt.budget_id = bvr.budget_id
554: AND bvr.budget_version_id = bdt.budget_version_id
555: AND bdt.budget_detail_id = bpr.budget_detail_id

Line 579: pqh_budget_elements bel

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
580: WHERE
581: bgt.budget_id = bvr.budget_id
582: AND bvr.budget_version_id = bdt.budget_version_id
583: AND bdt.budget_detail_id = bpr.budget_detail_id

Line 607: pqh_budget_elements bel

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
608: WHERE
609: bgt.budget_id = bvr.budget_id
610: AND bvr.budget_version_id = bdt.budget_version_id
611: AND bdt.budget_detail_id = bpr.budget_detail_id

Line 1517: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

1513: FUNCTION get_posn_element_bdgt_amt
1514: (
1515: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1516: p_position_id IN per_positions.position_id%TYPE,
1517: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1518: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1519: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1520: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
1521: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 1546: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

1542: --
1543: FUNCTION get_job_element_bdgt
1544: (
1545: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1546: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1547: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1548: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1549: p_job_id IN per_jobs.job_id%TYPE,
1550: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE

Line 1574: pqh_budget_elements bel

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
1575:
1576: WHERE
1577: bgt.budget_id = bvr.budget_id
1578: AND bvr.budget_version_id = bdt.budget_version_id

Line 1603: pqh_budget_elements bel

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
1604:
1605:
1606: WHERE
1607: bgt.budget_id = bvr.budget_id

Line 1634: pqh_budget_elements bel

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
1635:
1636:
1637: WHERE
1638: bgt.budget_id = bvr.budget_id

Line 1693: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

1689: FUNCTION get_job_element_bdgt_amt
1690: (
1691: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1692: p_job_id IN per_jobs.job_id%TYPE,
1693: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1694: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1695: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1696: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
1697: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 1781: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

1777: --
1778: FUNCTION get_grde_element_bdgt
1779: (
1780: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1781: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1782: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1783: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1784: p_grade_id IN per_grades.grade_id%TYPE,
1785: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE

Line 1809: pqh_budget_elements bel

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
1810:
1811: WHERE
1812: bgt.budget_id = bvr.budget_id
1813: AND bvr.budget_version_id = bdt.budget_version_id

Line 1838: pqh_budget_elements bel

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
1839:
1840:
1841: WHERE
1842: bgt.budget_id = bvr.budget_id

Line 1869: pqh_budget_elements bel

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
1870:
1871:
1872: WHERE
1873: bgt.budget_id = bvr.budget_id

Line 1928: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

1924: FUNCTION get_grde_element_bdgt_amt
1925: (
1926: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1927: p_grade_id IN per_grades.grade_id%TYPE,
1928: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1929: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1930: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1931: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
1932: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 2019: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

2015: ---------------------------------------------------------------------------------------------------------
2016: FUNCTION get_orgn_element_bdgt
2017: (
2018: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2019: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2020: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2021: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2022: p_organization_id IN hr_organization_units.organization_id%TYPE,
2023: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE

Line 2047: pqh_budget_elements bel

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
2048:
2049: WHERE
2050: bgt.budget_id = bvr.budget_id
2051: AND bvr.budget_version_id = bdt.budget_version_id

Line 2076: pqh_budget_elements bel

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
2077:
2078:
2079: WHERE
2080: bgt.budget_id = bvr.budget_id

Line 2107: pqh_budget_elements bel

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
2108:
2109:
2110: WHERE
2111: bgt.budget_id = bvr.budget_id

Line 2166: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

2162: FUNCTION get_orgn_element_bdgt_amt
2163: (
2164: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2165: p_organization_id IN hr_organization_units.organization_id%TYPE,
2166: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2167: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2168: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2169: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2170: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 2288: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

2284: FUNCTION get_posn_elmnt_actual_cmmtmnts
2285: (
2286: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2287: p_position_id IN per_positions.position_id%TYPE,
2288: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2289: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2290: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2291: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2292: p_value_type IN varchar2 DEFAULT 'T',

Line 2327: pqh_budget_elements bel

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 )
2330: AND bgt.budget_id = bvr.budget_id
2331: AND bvr.budget_version_id = bdt.budget_version_id

Line 2407: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

2403: FUNCTION get_job_elmnt_actual_cmmtmnts
2404: (
2405: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2406: p_job_id IN per_jobs.job_id%TYPE,
2407: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2408: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2409: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2410: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2411: p_value_type IN varchar2 DEFAULT 'T',

Line 2446: pqh_budget_elements bel

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 )
2449: AND bgt.budget_id = bvr.budget_id
2450: AND bvr.budget_version_id = bdt.budget_version_id

Line 2524: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

2520: FUNCTION get_grde_elmnt_actual_cmmtmnts
2521: (
2522: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2523: p_grade_id IN per_grades.grade_id%TYPE,
2524: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2525: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2526: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2527: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2528: p_value_type IN varchar2 DEFAULT 'T',

Line 2563: pqh_budget_elements bel

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 )
2566: AND bgt.budget_id = bvr.budget_id
2567: AND bvr.budget_version_id = bdt.budget_version_id

Line 2640: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

2636: FUNCTION get_orgn_elmnt_actual_cmmtmnts
2637: (
2638: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2639: p_organization_id IN hr_organization_units.organization_id%TYPE,
2640: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2641: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2642: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2643: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2644: p_value_type IN varchar2 DEFAULT 'T',

Line 2679: pqh_budget_elements bel

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 )
2682: AND bgt.budget_id = bvr.budget_id
2683: AND bvr.budget_version_id = bdt.budget_version_id

Line 2769: l_element_type_id pqh_budget_elements.element_type_id%TYPE;

2765: l_proc varchar2(72) := g_package||'get_posn_bset_actual_cmmtmnts';
2766: l_total_amt NUMBER := 0;
2767: l_curr_ver_tot NUMBER := 0;
2768: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
2769: l_element_type_id pqh_budget_elements.element_type_id%TYPE;
2770: l_business_group_id number;
2771:
2772: CURSOR csr_bdgt_positions IS
2773: SELECT DISTINCT

Line 3208: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

3204: --
3205: ---------------------------------------------------------------------------------------------------------
3206: FUNCTION get_elem_posn_budget_amt
3207: (
3208: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3209: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3210: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3211: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3212: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 3304: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

3300: -- JOB
3301: --
3302: FUNCTION get_elem_job_budget_amt
3303: (
3304: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3305: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3306: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3307: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3308: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 3401: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

3397: -- GRADE
3398: --
3399: FUNCTION get_elem_grde_budget_amt
3400: (
3401: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3402: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3403: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3404: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3405: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 3496: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

3492: -- ORGANIZATION
3493: --
3494: FUNCTION get_elem_orgn_budget_amt
3495: (
3496: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3497: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3498: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3499: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3500: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 3591: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

3587:
3588: ---------------------------------------------------------------------------------------------------------
3589: FUNCTION get_elem_posn_actual_cmmtmnts
3590: (
3591: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3592: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3593: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3594: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3595: p_value_type IN varchar2 DEFAULT 'T',

Line 3623: pqh_budget_elements bel

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 )
3626: AND bgt.budget_id = bvr.budget_id
3627: AND bvr.budget_version_id = bdt.budget_version_id

Line 3699: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

3695: -- JOB
3696: --
3697: FUNCTION get_elem_job_actual_cmmtmnts
3698: (
3699: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3700: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3701: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3702: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3703: p_value_type IN varchar2 DEFAULT 'T',

Line 3731: pqh_budget_elements bel

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 )
3734: AND bgt.budget_id = bvr.budget_id
3735: AND bvr.budget_version_id = bdt.budget_version_id

Line 3806: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

3802: -- GRADE
3803: --
3804: FUNCTION get_elem_grde_actual_cmmtmnts
3805: (
3806: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3807: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3808: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3809: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3810: p_value_type IN varchar2 DEFAULT 'T',

Line 3838: pqh_budget_elements bel

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 )
3841: AND bgt.budget_id = bvr.budget_id
3842: AND bvr.budget_version_id = bdt.budget_version_id

Line 3913: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

3909: -- ORGANIZATION
3910: --
3911: FUNCTION get_elem_orgn_actual_cmmtmnts
3912: (
3913: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3914: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3915: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3916: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3917: p_value_type IN varchar2 DEFAULT 'T',

Line 3945: pqh_budget_elements bel

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 )
3948: AND bgt.budget_id = bvr.budget_id
3949: AND bvr.budget_version_id = bdt.budget_version_id

Line 4762: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

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,
4766: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 4848: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

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,
4852: p_value_type IN varchar2 DEFAULT 'T',

Line 4936: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

4932: -- ENTITY
4933: --
4934: FUNCTION get_elem_ent_budget_amt
4935: (
4936: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
4937: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
4938: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4939: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4940: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

Line 5006: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

5002: --
5003: --
5004: FUNCTION get_elem_ent_actual_cmmtmnts
5005: (
5006: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
5007: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
5008: p_start_date IN pqh_budgets.budget_start_date%TYPE,
5009: p_end_date IN pqh_budgets.budget_end_date%TYPE,
5010: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,