APPS.PQH_PTX_UTL dependencies on PQH_WORKSHEET_DETAILS

Line 56: from pqh_worksheet_details

52: p_job_id in number,
53: p_organization_id in number,
54: p_effective_date in date) is
55: cursor c1 is select worksheet_detail_id,object_version_number
56: from pqh_worksheet_details
57: where position_id is null
58: and position_transaction_id = p_position_transaction_id
59: for update of position_id;
60: begin

Line 67: pqh_worksheet_details_api.update_worksheet_detail(

63: pqh_wdt_shd.lck(
64: p_worksheet_detail_id => i.worksheet_detail_id,
65: p_object_version_number => i.object_version_number);
66: --
67: pqh_worksheet_details_api.update_worksheet_detail(
68: p_worksheet_detail_id => i.worksheet_detail_id,
69: p_position_id => p_position_id,
70: p_job_id => p_job_id,
71: p_organization_id => p_organization_id,

Line 3885: from pqh_worksheets wks, pqh_worksheet_details wdt

3881: --
3882: cursor c_worksheets(p_position_transaction_id number) is
3883: select distinct wks.worksheet_id, wks.budget_version_id,
3884: wdt.worksheet_detail_id, wdt.budget_detail_id
3885: from pqh_worksheets wks, pqh_worksheet_details wdt
3886: where wks.worksheet_id = wdt.worksheet_id
3887: and wks.worksheet_mode_cd = 'O'
3888: and wdt.position_transaction_id = p_position_transaction_id;
3889: --

Line 3892: from pqh_worksheet_details

3888: and wdt.position_transaction_id = p_position_transaction_id;
3889: --
3890: cursor c_worksheet_details(p_worksheet_detail_id number) is
3891: select *
3892: from pqh_worksheet_details
3893: where worksheet_detail_id = p_worksheet_detail_id;
3894: --
3895: cursor c_worksheet_periods(p_worksheet_detail_id number) is
3896: select *