APPS.PSB_WS_AMOUNTS_SETUP dependencies on PSB_WS_MATRIX

Line 26: and ((psb_ws_matrix.get_ws_line_year_st = 0

22: and WAL.Position_line_ID = p_position_line_id
23: and WAL.Service_Package_ID = p_service_package_id
24: and WAL.Element_Set_ID = p_element_set_id
25: and WAL.Budget_Year_ID = p_budget_year_id
26: and ((psb_ws_matrix.get_ws_line_year_st = 0
27: and wal.end_stage_seq is null)
28: or
29: (psb_ws_matrix.get_ws_line_year_st between
30: wal.start_stage_seq and nvl(wal.end_stage_seq, 9.99e125)));

Line 29: (psb_ws_matrix.get_ws_line_year_st between

25: and WAL.Budget_Year_ID = p_budget_year_id
26: and ((psb_ws_matrix.get_ws_line_year_st = 0
27: and wal.end_stage_seq is null)
28: or
29: (psb_ws_matrix.get_ws_line_year_st between
30: wal.start_stage_seq and nvl(wal.end_stage_seq, 9.99e125)));
31: -- and p_stage between WAL.START_STAGE_SEQ AND WAL.CURRENT_STAGE_SEQ;
32: Exception When No_Data_Found then
33: Null;