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_EFC dependencies on PQH_BUDGET_VERSIONS

Line 38: pqh_budget_versions bvr

34: --
35: CURSOR csr_bvr IS
36: SELECT currency_code
37: FROM pqh_budgets bgt,
38: pqh_budget_versions bvr
39: WHERE bgt.budget_id = bvr.budget_id
40: AND bvr.budget_version_id = p_primary_key;
41: --
42: --

Line 46: pqh_budget_versions bvr,

42: --
43: CURSOR csr_bdt IS
44: SELECT currency_code
45: FROM pqh_budgets bgt,
46: pqh_budget_versions bvr,
47: pqh_budget_details bdt
48: WHERE bgt.budget_id = bvr.budget_id
49: AND bvr.budget_version_id = bdt.budget_version_id
50: AND bdt.budget_detail_id = p_primary_key;

Line 56: pqh_budget_versions bvr,

52: --
53: CURSOR csr_bpr IS
54: SELECT currency_code
55: FROM pqh_budgets bgt,
56: pqh_budget_versions bvr,
57: pqh_budget_details bdt,
58: pqh_budget_periods bpr
59: WHERE bgt.budget_id = bvr.budget_id
60: AND bvr.budget_version_id = bdt.budget_version_id

Line 68: pqh_budget_versions bvr,

64: --
65: CURSOR csr_bst IS
66: SELECT currency_code
67: FROM pqh_budgets bgt,
68: pqh_budget_versions bvr,
69: pqh_budget_details bdt,
70: pqh_budget_periods bpr,
71: pqh_budget_sets bst
72: WHERE bgt.budget_id = bvr.budget_id

Line 118: pqh_budget_versions bvr,

114: --
115: CURSOR csr_pec IS
116: SELECT currency_code
117: FROM pqh_budgets bgt,
118: pqh_budget_versions bvr,
119: pqh_element_commitments pec
120: WHERE bgt.budget_id = bvr.budget_id
121: AND bvr.budget_version_id = pec.budget_version_id
122: AND pec.element_commitment_id = p_primary_key;

Line 128: pqh_budget_versions bvr,

124: --
125: CURSOR csr_bre IS
126: SELECT currency_code
127: FROM pqh_budgets bgt,
128: pqh_budget_versions bvr,
129: pqh_budget_pools bpl,
130: pqh_bdgt_pool_realloctions bre
131: WHERE bgt.budget_id = bvr.budget_id
132: AND bvr.budget_version_id = bpl.budget_version_id

Line 266: l_converted_amt pqh_budget_versions.budget_unit1_value%TYPE;

262: This function will return the converted amount
263: */
264:
265: l_proc varchar2(72) := g_package||'convert_value';
266: l_converted_amt pqh_budget_versions.budget_unit1_value%TYPE;
267: l_unit1_type varchar2(30);
268: l_unit2_type varchar2(30);
269: l_unit3_type varchar2(30);
270: l_existing_curr_cd varchar2(150);

Line 278: pqh_budget_versions bvr,

274: SELECT pst1.system_type_cd ,
275: pst2.system_type_cd ,
276: pst3.system_type_cd
277: FROM pqh_budgets bgt,
278: pqh_budget_versions bvr,
279: per_shared_types_vl pst1 ,
280: per_shared_types_vl pst2 ,
281: per_shared_types_vl pst3
282: WHERE bgt.budget_id = bvr.budget_id

Line 294: pqh_budget_versions bvr,

290: SELECT pst1.system_type_cd ,
291: pst2.system_type_cd ,
292: pst3.system_type_cd
293: FROM pqh_budgets bgt,
294: pqh_budget_versions bvr,
295: pqh_budget_details bdt,
296: per_shared_types_vl pst1 ,
297: per_shared_types_vl pst2 ,
298: per_shared_types_vl pst3

Line 312: pqh_budget_versions bvr,

308: SELECT pst1.system_type_cd ,
309: pst2.system_type_cd ,
310: pst3.system_type_cd
311: FROM pqh_budgets bgt,
312: pqh_budget_versions bvr,
313: pqh_budget_details bdt,
314: pqh_budget_periods bpr,
315: per_shared_types_vl pst1 ,
316: per_shared_types_vl pst2 ,

Line 332: pqh_budget_versions bvr,

328: SELECT pst1.system_type_cd ,
329: pst2.system_type_cd ,
330: pst3.system_type_cd
331: FROM pqh_budgets bgt,
332: pqh_budget_versions bvr,
333: pqh_budget_details bdt,
334: pqh_budget_periods bpr,
335: pqh_budget_sets bst,
336: per_shared_types_vl pst1 ,