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_SETS

Line 942: pqh_budget_sets bst, pqh_budget_periods bpr

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
946: AND bpr.budget_detail_id = p_budget_detail_id

Line 967: pqh_budget_sets bst,

963: SUM((NVL(bfs.dflt_dist_percentage,0)*0.01)*(NVL(bel.dflt_dist_percentage,0)*0.01)*NVL(bst.budget_unit2_value,0)) Amount2,
964: SUM((NVL(bfs.dflt_dist_percentage,0)*0.01)*(NVL(bel.dflt_dist_percentage,0)*0.01)*NVL(bst.budget_unit3_value,0)) Amount3
965: FROM pqh_dflt_fund_srcs bfs,
966: pqh_dflt_budget_elements bel,
967: pqh_budget_sets bst,
968: pqh_budget_periods bpr
969: WHERE bpr.budget_period_id = bst.budget_period_id
970: AND bst.dflt_budget_set_id = bel.dflt_budget_set_id
971: AND bel.dflt_budget_element_id = bfs.dflt_budget_element_id

Line 2430: l_budget_sets_rec pqh_budget_sets%ROWTYPE;

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
2434: SELECT (NVL(srcs.distribution_percentage,0) * .01) *

Line 2431: l_amount1 pqh_budget_sets.budget_unit1_value%TYPE;

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
2434: SELECT (NVL(srcs.distribution_percentage,0) * .01) *
2435: (NVL(elem.distribution_percentage,0) * .01) *

Line 2439: pqh_budget_sets sets

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

Line 2479: l_budget_sets_rec pqh_budget_sets%ROWTYPE;

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
2483: SELECT (NVL(srcs.distribution_percentage,0) * .01) *

Line 2480: l_amount2 pqh_budget_sets.budget_unit2_value%TYPE;

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
2483: SELECT (NVL(srcs.distribution_percentage,0) * .01) *
2484: (NVL(elem.distribution_percentage,0) * .01) *

Line 2488: pqh_budget_sets sets

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

Line 2530: l_budget_sets_rec pqh_budget_sets%ROWTYPE;

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
2534: SELECT (NVL(srcs.distribution_percentage,0) * .01) *

Line 2531: l_amount3 pqh_budget_sets.budget_unit3_value%TYPE;

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
2534: SELECT (NVL(srcs.distribution_percentage,0) * .01) *
2535: (NVL(elem.distribution_percentage,0) * .01) *

Line 2539: pqh_budget_sets sets

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

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