[Home] [Help]
33: --
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: --
41: --
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
51: --
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
63: --
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
77: --
78: --
79: CURSOR csr_wdt IS
80: SELECT currency_code
81: FROM pqh_budgets bgt,
82: pqh_worksheets wks,
83: pqh_worksheet_details wdt
84: WHERE bgt.budget_id = wks.budget_id
85: AND wks.worksheet_id = wdt.worksheet_id
87: --
88: --
89: CURSOR csr_wpr IS
90: SELECT currency_code
91: FROM pqh_budgets bgt,
92: pqh_worksheets wks,
93: pqh_worksheet_details wdt,
94: pqh_worksheet_periods wpr
95: WHERE bgt.budget_id = wks.budget_id
99: --
100: --
101: CURSOR csr_wst IS
102: SELECT currency_code
103: FROM pqh_budgets bgt,
104: pqh_worksheets wks,
105: pqh_worksheet_details wdt,
106: pqh_worksheet_periods wpr,
107: pqh_worksheet_budget_sets wst
113: --
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
123: --
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
273: CURSOR csr_bvr_units IS
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
289: CURSOR csr_bdt_units IS
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 ,
307: CURSOR csr_bpr_units IS
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 ,
327: CURSOR csr_bst_units IS
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,
349: CURSOR csr_wdt_units IS
350: SELECT pst1.system_type_cd ,
351: pst2.system_type_cd ,
352: pst3.system_type_cd
353: FROM pqh_budgets bgt,
354: pqh_worksheets wks,
355: pqh_worksheet_details wdt,
356: per_shared_types_vl pst1 ,
357: per_shared_types_vl pst2 ,
367: CURSOR csr_wpr_units IS
368: SELECT pst1.system_type_cd ,
369: pst2.system_type_cd ,
370: pst3.system_type_cd
371: FROM pqh_budgets bgt,
372: pqh_worksheets wks,
373: pqh_worksheet_details wdt,
374: pqh_worksheet_periods wpr,
375: per_shared_types_vl pst1 ,
387: CURSOR csr_wst_units IS
388: SELECT pst1.system_type_cd ,
389: pst2.system_type_cd ,
390: pst3.system_type_cd
391: FROM pqh_budgets bgt,
392: pqh_worksheets wks,
393: pqh_worksheet_details wdt,
394: pqh_worksheet_periods wpr,
395: pqh_worksheet_budget_sets wst,