APPS.PSB_WS_YEAR_TOTAL dependencies on PSB_WS_YEAR_AMOUNTS_V

Line 107: FROM PSB_WS_YEAR_AMOUNTS_V WYA

103: select NVL(SUM(column1),0) A, NVL(SUM(column2),0) B, NVL(SUM(column3),0) C, NVL(SUM(column4),0) D,
104: NVL(SUM(column5),0) E, NVL(SUM(column6),0) F, NVL(SUM(column7),0) G, NVL(SUM(column8),0) H,
105: NVL(SUM(column9),0) I, NVL(SUM(column10),0) J, NVL(SUM(column11),0) K, NVL(SUM(column12),0) L,
106: DECODE(UPPER(account_type),'L','I','O','I','R','I','C','I','A','E','E') account_type
107: FROM PSB_WS_YEAR_AMOUNTS_V WYA
108: WHERE worksheet_id = p_worksheet_id
109: -- Changed reference to 'T' from 'C' for All accounts for bug 3191611
110: AND (p_account_flag = 'T' OR account_type = p_account_flag
111: OR account_type = DECODE(p_account_flag,'P','R','~')

Line 145: FROM PSB_WS_YEAR_AMOUNTS_V WYA

141: select NVL(SUM(column1),0) A, NVL(SUM(column2),0) B, NVL(SUM(column3),0) C, NVL(SUM(column4),0) D,
142: NVL(SUM(column5),0) E, NVL(SUM(column6),0) F, NVL(SUM(column7),0) G, NVL(SUM(column8),0) H,
143: NVL(SUM(column9),0) I, NVL(SUM(column10),0) J, NVL(SUM(column11),0) K, NVL(SUM(column12),0) L,
144: DECODE(UPPER(account_type),'L','I','O','I','R','I','C','I','A','E','E') account_type
145: FROM PSB_WS_YEAR_AMOUNTS_V WYA
146: WHERE worksheet_id = p_worksheet_id
147: -- Changed reference to 'T' from 'C' for All accounts for bug 3191611
148: AND (p_account_flag = 'T' OR account_type = p_account_flag
149: OR account_type = DECODE(p_account_flag,'P','R','~')