APPS.GL_ENT_FUNC_BAL_UPGRADE_PKG dependencies on GL_LEDGERS

Line 285: ' from gl_ledgers ' ||

281: ccid_range ||
282: 'AND b1.translated_flag IS NULL ' ||
283: 'AND b1.currency_code = ' ||
284: ' (select currency_code ' ||
285: ' from gl_ledgers ' ||
286: ' where ledger_id = b1.ledger_id)';
287:
288: IF (x_src_table = g_std_bal_table) THEN
289: EXECUTE IMMEDIATE StdUpdateFuncEntBalStr USING x_start_id, x_end_id;

Line 488: 'FROM ' || x_src_table || ' b1, gl_ledgers ldg ' ||

484: ' ''C'', -b1.period_aggregate34,0),0)), ' ||
485: 'sum(decode(b1.currency_code, ldg.currency_code,' ||
486: ' decode(b1.currency_type, ''U'', b1.period_aggregate35,' ||
487: ' ''C'', -b1.period_aggregate35,0),0)) ' ||
488: 'FROM ' || x_src_table || ' b1, gl_ledgers ldg ' ||
489: 'WHERE ldg.ledger_id = b1.ledger_id ' ||
490: 'AND ldg.currency_code = b1.currency_code ' ||
491: 'AND ldg.enable_average_balances_flag = ''Y'' ' ||
492: 'AND b1.actual_flag = ''A'' ' ||

Line 608: ' from gl_ledgers' ||

604: ' AND di.currency_code = b1.currency_code' ||
605: ' AND di.period_name = b1.period_name) ' ||
606: 'WHERE b1.currency_code = ' ||
607: ' (select currency_code' ||
608: ' from gl_ledgers' ||
609: ' where ledger_id = b1.ledger_id) ' ||
610: 'AND b1.actual_flag = ''A'' ' ||
611: 'AND b1.currency_type = ''E'' ' ||
612: 'AND b1.converted_from_currency IS NULL ' ||

Line 1181: FROM GL_LEDGERS

1177: sql_stmt VARCHAR2(200);
1178:
1179: CURSOR c_ledgers IS
1180: SELECT ledger_id
1181: FROM GL_LEDGERS
1182: WHERE object_type_code = 'L';
1183:
1184: -- requests that have completed move/merge successfully
1185: CURSOR c_mm_requests(v_ledger_id NUMBER) IS