DBA Data[Home] [Help]

APPS.CE_CP_PRIORDAY dependencies on CE_CP_WORKSHEET_HEADERS

Line 52: l_ws_id CE_CP_WORKSHEET_HEADERS.worksheet_header_id%TYPE;

48:
49: END set_parameters;
50:
51: PROCEDURE calculate_summary IS
52: l_ws_id CE_CP_WORKSHEET_HEADERS.worksheet_header_id%TYPE;
53: l_bank_account_id CE_CP_PRIORDAY_BALANCES.bank_account_id%TYPE;
54: l_currency_code VARCHAR2(15);
55: l_statement_date DATE;
56: tmp_balance NUMBER;

Line 79: FROM CE_CP_WORKSHEET_HEADERS

75: AND next_stmt_date >= CE_CP_PRIORDAY.G_as_of_date;
76:
77: CURSOR ws_cursor IS
78: SELECT worksheet_header_id
79: FROM CE_CP_WORKSHEET_HEADERS
80: WHERE pd_flag = 'Y'
81: AND (CE_CP_PRIORDAY.G_worksheet_header_id is null
82: OR worksheet_header_id = CE_CP_PRIORDAY.G_worksheet_header_id);
83: