APPS.PSB_WS_POS2 dependencies on PSB_WS_FTE_LINES

Line 4563: select /*+ ORDERED INDEX(a PSB_WS_FTE_LINES_N1) */

4559: and budget_year_id = p_budget_year_id
4560: and end_stage_seq is null;
4561:
4562: cursor c_Position_FTE is
4563: select /*+ ORDERED INDEX(a PSB_WS_FTE_LINES_N1) */
4564: fte_line_id, annual_fte, service_package_id
4565: from PSB_WS_FTE_LINES a
4566: where position_line_id = p_position_line_id
4567: and budget_year_id = p_budget_year_id

Line 4565: from PSB_WS_FTE_LINES a

4561:
4562: cursor c_Position_FTE is
4563: select /*+ ORDERED INDEX(a PSB_WS_FTE_LINES_N1) */
4564: fte_line_id, annual_fte, service_package_id
4565: from PSB_WS_FTE_LINES a
4566: where position_line_id = p_position_line_id
4567: and budget_year_id = p_budget_year_id
4568: and end_stage_seq is null;
4569: