APPS.PQH_COMMITMENT_POSTING dependencies on PQH_BUDGET_SETS

Line 999: From pqh_budget_sets bst

995: Cursor csr_budget_sets is
996: Select bst.budget_set_id,decode(p_budget_unit_seq,1,bst.budget_unit1_value,
997: 2,bst.budget_unit2_value,
998: bst.budget_unit3_value)
999: From pqh_budget_sets bst
1000: Where bst.budget_period_id = p_budget_period_id;
1001: --
1002: Cursor csr_dist_money is
1003: Select distinct bst.budget_set_id,

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 1012: l_budget_set_id pqh_budget_sets.budget_set_id%type;

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: --
1012: l_budget_set_id pqh_budget_sets.budget_set_id%type;
1013: l_budgeted_amt pqh_budget_sets.budget_unit1_value%type;
1014: l_total_budgeted_amt pqh_budget_sets.budget_unit1_value%type;
1015: cnt number(10) := 0;
1016: --

Line 1013: l_budgeted_amt pqh_budget_sets.budget_unit1_value%type;

1009: and bst.budget_set_id = bel.budget_set_id
1010: and bel.element_type_id = p_element_type_id ;
1011: --
1012: l_budget_set_id pqh_budget_sets.budget_set_id%type;
1013: l_budgeted_amt pqh_budget_sets.budget_unit1_value%type;
1014: l_total_budgeted_amt pqh_budget_sets.budget_unit1_value%type;
1015: cnt number(10) := 0;
1016: --
1017: --

Line 1014: l_total_budgeted_amt pqh_budget_sets.budget_unit1_value%type;

1010: and bel.element_type_id = p_element_type_id ;
1011: --
1012: l_budget_set_id pqh_budget_sets.budget_set_id%type;
1013: l_budgeted_amt pqh_budget_sets.budget_unit1_value%type;
1014: l_total_budgeted_amt pqh_budget_sets.budget_unit1_value%type;
1015: cnt number(10) := 0;
1016: --
1017: --
1018: l_proc varchar2(72) := g_package||'build_budget_set_ratio_table';

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 1652: l_budget_set_id pqh_budget_sets.budget_set_id%TYPE;

1648: --
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;

Line 1676: pqh_budget_sets bst

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;
1680: --

Line 1690: pqh_budget_sets bst, pqh_budget_periods bpr

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
1694: AND bel.budget_element_id = bfs.budget_element_id