APPS.PQH_WKS_BUDGET dependencies on PQH_WORKSHEET_BUDGET_SETS

Line 1676: from pqh_worksheet_budget_sets where worksheet_period_id = p_worksheet_period_id;

1672: cursor c_worksheet_periods is select worksheet_period_id,object_version_number
1673: from pqh_worksheet_periods where worksheet_detail_id = p_worksheet_detail_id;
1674: cursor c_worksheet_budget_sets(p_worksheet_period_id number) is
1675: select worksheet_budget_set_id,object_version_number
1676: from pqh_worksheet_budget_sets where worksheet_period_id = p_worksheet_period_id;
1677: cursor c_worksheet_bdgt_elmnts (p_worksheet_budget_set_id number) is
1678: select worksheet_bdgt_elmnt_id,object_version_number
1679: from pqh_worksheet_bdgt_elmnts where worksheet_budget_set_id = p_worksheet_budget_set_id;
1680: cursor c_worksheet_fund_srcs (p_worksheet_bdgt_elmnt_id number) is

Line 1701: pqh_worksheet_budget_sets_api.DELETE_WORKSHEET_BUDGET_SET(

1697: pqh_worksheet_bdgt_elmnts_api.DELETE_WORKSHEET_BDGT_ELMNT(
1698: P_WORKSHEET_BDGT_ELMNT_ID => k.worksheet_bdgt_elmnt_id,
1699: P_OBJECT_VERSION_NUMBER => k.object_version_number);
1700: end loop;
1701: pqh_worksheet_budget_sets_api.DELETE_WORKSHEET_BUDGET_SET(
1702: P_WORKSHEET_BUDGET_SET_ID => j.worksheet_budget_set_id,
1703: P_EFFECTIVE_DATE => trunc(sysdate),
1704: P_OBJECT_VERSION_NUMBER => j.object_version_number);
1705: end loop;