DBA Data[Home] [Help]

APPS.CE_CP_PRIORDAY dependencies on CE_CP_OPEN_BAL_V

Line 62: FROM CE_CP_OPEN_BAL_V OPEN,

58: CURSOR wsba_cursor(p_ws_id NUMBER) IS
59: SELECT WBA.bank_account_id,
60: WBA.currency_code,
61: OPEN.statement_date
62: FROM CE_CP_OPEN_BAL_V OPEN,
63: CE_CP_WS_BA_V WBA
64: WHERE WBA.worksheet_header_id = p_ws_id
65: AND WBA.bank_account_id = OPEN.bank_account_id
66: AND OPEN.statement_date < CE_CP_PRIORDAY.G_as_of_date

Line 73: FROM CE_CP_OPEN_BAL_V

69: CURSOR ba_cursor IS
70: SELECT bank_account_id,
71: currency_code,
72: statement_date
73: FROM CE_CP_OPEN_BAL_V
74: WHERE statement_date < CE_CP_PRIORDAY.G_as_of_date
75: AND next_stmt_date >= CE_CP_PRIORDAY.G_as_of_date;
76:
77: CURSOR ws_cursor IS