APPS.PSB_WS_YEAR_TOTAL dependencies on PSB_WS_YEAR_POSITION_AMOUNTS_V

Line 409: FROM PSB_WS_YEAR_POSITION_AMOUNTS_V WYA

405: cursor c_sum_all is
406: select NVL(SUM(column1),0) A, NVL(SUM(column2),0) B, NVL(SUM(column3),0) C, NVL(SUM(column4),0) D,
407: NVL(SUM(column5),0) E, NVL(SUM(column6),0) F, NVL(SUM(column7),0) G, NVL(SUM(column8),0) H,
408: NVL(SUM(column9),0) I, NVL(SUM(column10),0) J, NVL(SUM(column11),0) K, NVL(SUM(column12),0) L
409: FROM PSB_WS_YEAR_POSITION_AMOUNTS_V WYA
410: WHERE worksheet_id = pworksheet_id
411: AND position_line_id = pposition_line_id
412: AND ((pcurrency_flag = 'C' AND currency_code <> 'STAT') OR (pcurrency_flag = 'S' AND currency_code = 'STAT'))
413: AND template_id is null

Line 437: FROM PSB_WS_YEAR_POSITION_AMOUNTS_V WYA

433: cursor c_sum_partial is
434: select NVL(SUM(column1),0) A, NVL(SUM(column2),0) B, NVL(SUM(column3),0) C, NVL(SUM(column4),0) D,
435: NVL(SUM(column5),0) E, NVL(SUM(column6),0) F, NVL(SUM(column7),0) G, NVL(SUM(column8),0) H,
436: NVL(SUM(column9),0) I, NVL(SUM(column10),0) J, NVL(SUM(column11),0) K, NVL(SUM(column12),0) L
437: FROM PSB_WS_YEAR_POSITION_AMOUNTS_V WYA
438: WHERE worksheet_id = pworksheet_id
439: AND position_line_id = pposition_line_id
440: AND ((pcurrency_flag = 'C' AND currency_code <> 'STAT') OR (pcurrency_flag = 'S' AND currency_code = 'STAT'))
441: AND template_id is null