[Home] [Help]
4543:
4544: l_api_name CONSTANT VARCHAR2(30) := 'Update_Position_Cost';
4545:
4546: cursor c_Position_Dist is
4547: select /*+ ORDERED INDEX(a PSB_WS_ACCOUNT_LINES_N5) */
4548: account_line_id, code_combination_id,
4549: service_package_id, element_set_id, budget_group_id
4550: from PSB_WS_ACCOUNT_LINES a
4551: where position_line_id = p_position_line_id
4546: cursor c_Position_Dist is
4547: select /*+ ORDERED INDEX(a PSB_WS_ACCOUNT_LINES_N5) */
4548: account_line_id, code_combination_id,
4549: service_package_id, element_set_id, budget_group_id
4550: from PSB_WS_ACCOUNT_LINES a
4551: where position_line_id = p_position_line_id
4552: and budget_year_id = p_budget_year_id
4553: and end_stage_seq is null;
4554: