DBA Data[Home] [Help]

APPS.PQH_EFC dependencies on PQH_BUDGET_DETAILS

Line 47: pqh_budget_details bdt

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

Line 57: pqh_budget_details bdt,

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
61: AND bdt.budget_detail_id = bpr.budget_detail_id

Line 69: pqh_budget_details bdt,

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
73: AND bvr.budget_version_id = bdt.budget_version_id

Line 295: pqh_budget_details bdt,

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
299: WHERE bgt.budget_id = bvr.budget_id

Line 313: pqh_budget_details bdt,

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 ,
317: per_shared_types_vl pst3

Line 333: pqh_budget_details bdt,

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 ,
337: per_shared_types_vl pst2 ,