DBA Data[Home] [Help]

APPS.PSB_EXCEL2_PVT dependencies on PSB_WS_COLUMNS_I

Line 766: FROM PSB_WS_COLUMNS_I

762: BUDGET_YEAR_ID,
763: BUDGET_YEAR_NAME,
764: BALANCE_TYPE,
765: YEAR_CATEGORY_TYPE
766: FROM PSB_WS_COLUMNS_I
767: WHERE EXPORT_ID = g_export_id
768: AND EXPORT_WORKSHEET_TYPE = 'A'
769: ORDER BY COLUMN_NUMBER
770: )

Line 1288: FROM PSB_WS_COLUMNS_I

1284: BUDGET_PERIOD_ID,
1285: BUDGET_PERIOD_NAME,
1286: BALANCE_TYPE,
1287: YEAR_CATEGORY_TYPE
1288: FROM PSB_WS_COLUMNS_I
1289: WHERE EXPORT_ID = g_export_id
1290: AND EXPORT_WORKSHEET_TYPE = 'P'
1291: ORDER BY COLUMN_NUMBER
1292: )

Line 1314: FROM psb_ws_columns_i

1310: min(column_number)+1 percent_column,
1311: min(column_number)+2 period_start_column,
1312: max(column_number) period_end_column,
1313: budget_year_id
1314: FROM psb_ws_columns_i
1315: WHERE export_id = g_export_id
1316: AND export_worksheet_type = 'P'
1317: AND balance_type = 'E'
1318: GROUP BY budget_year_id )

Line 3970: delete from psb_ws_columns_i

3966: delete from psb_ws_line_balances_i
3967: where export_id = g_export_id
3968: and export_worksheet_type = p_export_worksheet_type;
3969:
3970: delete from psb_ws_columns_i
3971: where export_id = g_export_id
3972: and export_worksheet_type = p_export_worksheet_type;
3973:
3974: IF p_export_worksheet_type = 'A' THEN