DBA Data[Home] [Help]

APPS.PQH_WORKFLOW dependencies on PQH_WORKSHEET_DETAILS

Line 2324: from pqh_worksheets wks, pqh_worksheet_details wdt

2320: l_unit_name varchar2(200);
2321: l_avail_desc varchar2(200);
2322: l_budget_id number;
2323: cursor c0 is select wks.budget_id
2324: from pqh_worksheets wks, pqh_worksheet_details wdt
2325: where wdt.worksheet_detail_id = p_transaction_id
2326: and wdt.worksheet_id = wks.worksheet_id
2327: and wks.wf_transaction_category_id = p_tran_cat_id;
2328: cursor c1 is select attribute_name,column_name

Line 4577: from pqh_worksheet_details wkd, pqh_worksheets wks

4573: where position_transaction_id = p_transaction_id;
4574: elsif p_short_name ='BUDGET_WORKSHEET' then
4575: select wks.wf_transaction_category_id
4576: into l_txn_cat_id
4577: from pqh_worksheet_details wkd, pqh_worksheets wks
4578: where worksheet_detail_id = p_transaction_id
4579: and wks.worksheet_id = wkd.worksheet_id;
4580: elsif p_short_name ='PQH_BPR' then
4581: select wf_transaction_category_id