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_COMMITMENT_POSTING dependencies on PQH_BUDGET_ELEMENTS

Line 989: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

985: ---------------------------------------------------------------------------------------------------
986: --
987: Procedure build_budget_set_ratio_table(
988: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,
989: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
990: p_budget_unit_seq IN number,
991: p_budget_ratio_table IN OUT NOCOPY t_ratio_table) IS
992: --
993: --

Line 1007: from pqh_budget_sets bst,pqh_budget_elements bel

1003: Select distinct bst.budget_set_id,
1004: decode(p_budget_unit_seq,1,bst.budget_unit1_value,
1005: 2,bst.budget_unit2_value,
1006: bst.budget_unit3_value)
1007: from pqh_budget_sets bst,pqh_budget_elements bel
1008: Where bst.budget_period_id = p_budget_period_id
1009: and bst.budget_set_id = bel.budget_set_id
1010: and bel.element_type_id = p_element_type_id ;
1011: --

Line 1529: from pqh_budget_sets bst,pqh_budget_elements bel

1525:
1526: --
1527: Cursor csr_bdgt_elmnts is
1528: Select distinct bel.element_type_id
1529: from pqh_budget_sets bst,pqh_budget_elements bel
1530: Where bst.budget_period_id = p_budget_period_id
1531: and bst.budget_set_id = bel.budget_set_id;
1532: --
1533: l_commitment number := NULL;

Line 1653: l_budget_element_id pqh_budget_elements.budget_element_id%TYPE;

1649: -- local variables
1650: --
1651: l_budget_period_id pqh_budget_periods.budget_period_id%TYPE;
1652: l_budget_set_id pqh_budget_sets.budget_set_id%TYPE;
1653: l_budget_element_id pqh_budget_elements.budget_element_id%TYPE;
1654: l_element_type_id pqh_budget_elements.element_type_id%TYPE;
1655: l_el_distribution_percentage pqh_budget_fund_srcs.distribution_percentage%TYPE;
1656: l_budget_fund_src_id pqh_budget_fund_srcs.budget_fund_src_id%TYPE;
1657: l_cost_allocation_keyflex_id pqh_budget_fund_srcs.cost_allocation_keyflex_id%TYPE;

Line 1654: l_element_type_id pqh_budget_elements.element_type_id%TYPE;

1650: --
1651: l_budget_period_id pqh_budget_periods.budget_period_id%TYPE;
1652: l_budget_set_id pqh_budget_sets.budget_set_id%TYPE;
1653: l_budget_element_id pqh_budget_elements.budget_element_id%TYPE;
1654: l_element_type_id pqh_budget_elements.element_type_id%TYPE;
1655: l_el_distribution_percentage pqh_budget_fund_srcs.distribution_percentage%TYPE;
1656: l_budget_fund_src_id pqh_budget_fund_srcs.budget_fund_src_id%TYPE;
1657: l_cost_allocation_keyflex_id pqh_budget_fund_srcs.cost_allocation_keyflex_id%TYPE;
1658: l_project_id pqh_budget_fund_srcs.project_id%TYPE;

Line 1675: FROM pqh_budget_fund_srcs bfs, pqh_budget_elements bel,

1671: bfs.budget_fund_src_id,bfs.cost_allocation_keyflex_id,
1672: bfs.project_id,bfs.task_id,bfs.award_id,
1673: bfs.expenditure_type,bfs.organization_id,
1674: bfs.distribution_percentage
1675: FROM pqh_budget_fund_srcs bfs, pqh_budget_elements bel,
1676: pqh_budget_sets bst
1677: WHERE bst.budget_period_id = p_budget_period_id
1678: AND bst.budget_set_id = bel.budget_set_id
1679: AND bel.budget_element_id = bfs.budget_element_id;

Line 1689: FROM pqh_budget_fund_srcs bfs, pqh_budget_elements bel,

1685: bfs.task_id,
1686: bfs.award_id,
1687: bfs.expenditure_type,
1688: bfs.organization_id
1689: FROM pqh_budget_fund_srcs bfs, pqh_budget_elements bel,
1690: pqh_budget_sets bst, pqh_budget_periods bpr
1691: WHERE bpr.budget_detail_id = p_budget_detail_id
1692: AND bpr.budget_period_id = bst.budget_period_id
1693: AND bst.budget_set_id = bel.budget_set_id