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

Line 941: FROM pqh_budget_fund_srcs bfs, pqh_budget_elements bel,

937: bfs.organization_id,
938: SUM(pqh_gl_posting.get_amt1(bfs.budget_fund_src_id)) Amount1,
939: SUM(pqh_gl_posting.get_amt2(bfs.budget_fund_src_id)) Amount2,
940: SUM(pqh_gl_posting.get_amt3(bfs.budget_fund_src_id)) Amount3
941: FROM pqh_budget_fund_srcs bfs, pqh_budget_elements bel,
942: pqh_budget_sets bst, pqh_budget_periods bpr
943: WHERE bpr.budget_period_id = bst.budget_period_id
944: AND bst.budget_set_id = bel.budget_set_id
945: AND bel.budget_element_id = bfs.budget_element_id

Line 2429: l_budget_elements_rec pqh_budget_elements%ROWTYPE;

2425:
2426:
2427: l_proc varchar2(72) := g_package||'.get_amt1';
2428: l_budget_fund_srcs_rec pqh_budget_fund_srcs%ROWTYPE;
2429: l_budget_elements_rec pqh_budget_elements%ROWTYPE;
2430: l_budget_sets_rec pqh_budget_sets%ROWTYPE;
2431: l_amount1 pqh_budget_sets.budget_unit1_value%TYPE;
2432:
2433: CURSOR csr_bdgt_amt IS

Line 2438: pqh_budget_elements elem,

2434: SELECT (NVL(srcs.distribution_percentage,0) * .01) *
2435: (NVL(elem.distribution_percentage,0) * .01) *
2436: NVL(sets.budget_unit1_value,0)
2437: FROM pqh_budget_fund_srcs srcs,
2438: pqh_budget_elements elem,
2439: pqh_budget_sets sets
2440: WHERE srcs.budget_fund_src_id = p_budget_fund_src_id
2441: AND elem.budget_element_id = srcs.budget_element_id
2442: AND sets.budget_set_id = elem.budget_set_id;

Line 2478: l_budget_elements_rec pqh_budget_elements%ROWTYPE;

2474:
2475:
2476: l_proc varchar2(72) := g_package||'.get_amt2';
2477: l_budget_fund_srcs_rec pqh_budget_fund_srcs%ROWTYPE;
2478: l_budget_elements_rec pqh_budget_elements%ROWTYPE;
2479: l_budget_sets_rec pqh_budget_sets%ROWTYPE;
2480: l_amount2 pqh_budget_sets.budget_unit2_value%TYPE;
2481:
2482: CURSOR csr_bdgt_amt IS

Line 2487: pqh_budget_elements elem,

2483: SELECT (NVL(srcs.distribution_percentage,0) * .01) *
2484: (NVL(elem.distribution_percentage,0) * .01) *
2485: NVL(sets.budget_unit2_value,0)
2486: FROM pqh_budget_fund_srcs srcs,
2487: pqh_budget_elements elem,
2488: pqh_budget_sets sets
2489: WHERE srcs.budget_fund_src_id = p_budget_fund_src_id
2490: AND elem.budget_element_id = srcs.budget_element_id
2491: AND sets.budget_set_id = elem.budget_set_id;

Line 2529: l_budget_elements_rec pqh_budget_elements%ROWTYPE;

2525:
2526:
2527: l_proc varchar2(72) := g_package||'.get_amt3';
2528: l_budget_fund_srcs_rec pqh_budget_fund_srcs%ROWTYPE;
2529: l_budget_elements_rec pqh_budget_elements%ROWTYPE;
2530: l_budget_sets_rec pqh_budget_sets%ROWTYPE;
2531: l_amount3 pqh_budget_sets.budget_unit3_value%TYPE;
2532:
2533: CURSOR csr_bdgt_amt IS

Line 2538: pqh_budget_elements elem,

2534: SELECT (NVL(srcs.distribution_percentage,0) * .01) *
2535: (NVL(elem.distribution_percentage,0) * .01) *
2536: NVL(sets.budget_unit3_value,0)
2537: FROM pqh_budget_fund_srcs srcs,
2538: pqh_budget_elements elem,
2539: pqh_budget_sets sets
2540: WHERE srcs.budget_fund_src_id = p_budget_fund_src_id
2541: AND elem.budget_element_id = srcs.budget_element_id
2542: AND sets.budget_set_id = elem.budget_set_id;

Line 3829: pqh_budget_sets bst, pqh_budget_elements bel,

3825:
3826: CURSOR csr_cost_allocation_keyflex_id IS
3827: SELECT cost_allocation_keyflex_id
3828: FROM pqh_budget_details bdt, pqh_budget_periods bpr,
3829: pqh_budget_sets bst, pqh_budget_elements bel,
3830: pay_element_links pel
3831: WHERE bdt.budget_detail_id = bpr.budget_detail_id
3832: AND bpr.budget_period_id = bst.budget_period_id
3833: AND bst.budget_set_id = bel.budget_set_id

Line 4379: FROM pqh_budget_details bdt, pqh_budget_periods bpr, pqh_budget_sets bst, pqh_budget_elements bel, pqh_budget_fund_srcs bfs

4375: l_result varchar2(30);
4376:
4377: CURSOR csr_budget_details (p_budget_version_id IN number )IS
4378: SELECT bfs.budget_fund_src_id
4379: FROM pqh_budget_details bdt, pqh_budget_periods bpr, pqh_budget_sets bst, pqh_budget_elements bel, pqh_budget_fund_srcs bfs
4380: WHERE bdt.budget_version_id = p_budget_version_id
4381: and bdt.budget_detail_id = bpr.budget_detail_id
4382: and bpr.budget_period_id = bst.budget_period_id
4383: and bst.budget_set_id = bel.budget_set_id