DBA Data[Home] [Help]

APPS.PSB_EXCEL2_PVT dependencies on PSB_WS_LINES

Line 1229: psb_ws_lines wl

1225:
1226: cursor wal_cur is
1227: SELECT wal.account_line_id
1228: FROM psb_ws_account_lines wal,
1229: psb_ws_lines wl
1230: WHERE wl.worksheet_id = p_worksheet_id
1231: AND wl.account_line_id = wal.account_line_id
1232: AND wal.code_combination_id = p_ccid
1233: AND wal.service_package_id = p_spid

Line 2011: psb_ws_lines wl

2007:
2008: cursor wal_cur is
2009: SELECT wal.account_line_id
2010: FROM psb_ws_account_lines wal,
2011: psb_ws_lines wl
2012: WHERE wl.worksheet_id = p_worksheet_id
2013: AND wl.account_line_id = wal.account_line_id
2014: AND wal.position_line_id = p_position_line_id
2015: AND wal.code_combination_id = p_ccid

Line 3882: FROM psb_ws_account_lines wal , psb_ws_lines wl

3878: sum(period9_amount) a9,
3879: sum(period10_amount) a10,
3880: sum(period11_amount) a11,
3881: sum(period12_amount) a12
3882: FROM psb_ws_account_lines wal , psb_ws_lines wl
3883: WHERE wal.account_line_id = wl.account_line_id
3884: AND wl.worksheet_id = g_worksheet_id
3885: AND wal.position_line_id = p_position_line_id
3886: AND wal.element_set_id = p_element_set_id