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_SETS

Line 550: pqh_budget_sets bst,

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

Line 578: pqh_budget_sets bst,

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

Line 606: pqh_budget_sets bst,

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

Line 653: p_budget_set_id IN pqh_budget_sets.dflt_budget_set_id%TYPE,

649: ---------------------------------------------------------------------------------------------------------
650: FUNCTION get_posn_bset_bdgt
651: (
652: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
653: p_budget_set_id IN pqh_budget_sets.dflt_budget_set_id%TYPE,
654: p_start_date IN pqh_budgets.budget_start_date%TYPE,
655: p_end_date IN pqh_budgets.budget_end_date%TYPE,
656: p_position_id IN per_positions.position_id%TYPE,
657: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE

Line 680: pqh_budget_sets bst

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
682: bgt.budget_id = bvr.budget_id
683: AND bvr.budget_version_id = bdt.budget_version_id
684: AND bdt.budget_detail_id = bpr.budget_detail_id

Line 706: pqh_budget_sets bst

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
708: bgt.budget_id = bvr.budget_id
709: AND bvr.budget_version_id = bdt.budget_version_id
710: AND bdt.budget_detail_id = bpr.budget_detail_id

Line 732: pqh_budget_sets bst

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
734: bgt.budget_id = bvr.budget_id
735: AND bvr.budget_version_id = bdt.budget_version_id
736: AND bdt.budget_detail_id = bpr.budget_detail_id

Line 1573: pqh_budget_sets bst,

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

Line 1602: pqh_budget_sets bst,

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
1604:
1605:
1606: WHERE

Line 1633: pqh_budget_sets bst,

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
1635:
1636:
1637: WHERE

Line 1808: pqh_budget_sets bst,

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

Line 1837: pqh_budget_sets bst,

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
1839:
1840:
1841: WHERE

Line 1868: pqh_budget_sets bst,

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
1870:
1871:
1872: WHERE

Line 2046: pqh_budget_sets bst,

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

Line 2075: pqh_budget_sets bst,

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
2077:
2078:
2079: WHERE

Line 2106: pqh_budget_sets bst,

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
2108:
2109:
2110: WHERE

Line 2259: p_budget_set_id IN pqh_budget_sets.dflt_budget_set_id%TYPE,

2255: FUNCTION get_posn_bset_bdgt_amt
2256: (
2257: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2258: p_position_id IN per_positions.position_id%TYPE,
2259: p_budget_set_id IN pqh_budget_sets.dflt_budget_set_id%TYPE,
2260: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2261: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2262: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE
2263: )

Line 2326: pqh_budget_sets bst,

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

Line 2445: pqh_budget_sets bst,

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

Line 2562: pqh_budget_sets bst,

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

Line 2678: pqh_budget_sets bst,

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

Line 2757: p_budget_set_id IN pqh_budget_sets.dflt_budget_set_id%TYPE,

2753: FUNCTION get_posn_bset_actual_cmmtmnts
2754: (
2755: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2756: p_position_id IN per_positions.position_id%TYPE,
2757: p_budget_set_id IN pqh_budget_sets.dflt_budget_set_id%TYPE,
2758: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2759: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2760: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2761: p_value_type IN varchar2 DEFAULT 'T'

Line 2780: pqh_budget_sets bst

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
2784: AND bvr.budget_version_id = bdt.budget_version_id

Line 3622: pqh_budget_sets bst,

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

Line 3730: pqh_budget_sets bst,

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

Line 3837: pqh_budget_sets bst,

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

Line 3944: pqh_budget_sets bst,

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