DBA Data[Home] [Help]

APPS.PQH_EFC dependencies on PQH_WORKSHEET_DETAILS

Line 83: pqh_worksheet_details wdt

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
86: AND wdt.worksheet_detail_id = p_primary_key;
87: --

Line 93: pqh_worksheet_details wdt,

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
96: AND wks.worksheet_id = wdt.worksheet_id
97: AND wdt.worksheet_detail_id = wpr.worksheet_detail_id

Line 105: pqh_worksheet_details wdt,

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
108: WHERE bgt.budget_id = wks.budget_id
109: AND wks.worksheet_id = wdt.worksheet_id

Line 355: pqh_worksheet_details wdt,

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 ,
358: per_shared_types_vl pst3
359: WHERE bgt.budget_id = wks.budget_id

Line 373: pqh_worksheet_details wdt,

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 ,
376: per_shared_types_vl pst2 ,
377: per_shared_types_vl pst3

Line 393: pqh_worksheet_details wdt,

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,
396: per_shared_types_vl pst1 ,
397: per_shared_types_vl pst2 ,