APPS.PSB_WS_POS3 dependencies on PSB_WS_FTE_LINES

Line 5884: from PSB_WS_FTE_LINES a,

5880: where constraint_id = p_constraint_id;
5881:
5882: cursor c_SumAll is
5883: select sum(nvl(a.annual_fte, 0)) Sum_FTE
5884: from PSB_WS_FTE_LINES a,
5885: PSB_WORKSHEETS b
5886: where exists
5887: (select 1
5888: from PSB_WS_LINES_POSITIONS c,

Line 5906: from PSB_WS_FTE_LINES a,

5902: and b.worksheet_id = p_worksheet_id;
5903:
5904: cursor c_SumAllSP is
5905: select sum(nvl(a.annual_fte, 0)) Sum_FTE
5906: from PSB_WS_FTE_LINES a,
5907: PSB_WORKSHEETS b
5908: where exists
5909: (select 1
5910: from PSB_WS_LINES_POSITIONS c,

Line 5934: from PSB_WS_FTE_LINES a,

5930:
5931: cursor c_Sum is
5932: select /*+ ORDERED USE_NL(b a) INDEX(b PSB_WORKSHEETS_U1) INDEX(a PSB_WS_ELEMENT_LINES_N1) */
5933: sum(nvl(a.annual_fte, 0)) Sum_FTE
5934: from PSB_WS_FTE_LINES a,
5935: PSB_WORKSHEETS b
5936: where b.current_stage_seq between a.start_stage_seq and a.current_stage_seq
5937: and a.stage_set_id = b.stage_set_id
5938: and a.budget_year_id = p_budget_year_id

Line 5945: from PSB_WS_FTE_LINES a,

5941:
5942: cursor c_SumSP is
5943: select /*+ ORDERED USE_NL(b a) INDEX(b PSB_WORKSHEETS_U1) INDEX(a PSB_WS_ELEMENT_LINES_N1) */
5944: sum(nvl(a.annual_fte, 0)) Sum_FTE
5945: from PSB_WS_FTE_LINES a,
5946: PSB_WORKSHEETS b
5947: where exists
5948: (select 1
5949: from PSB_WS_SUBMIT_SERVICE_PACKAGES d